Shell Programming and Scripting

hi,

can anyone help me with spool command..
i want to spool a file.. i am getting the output of an sql query into a file in the unix environment.. i want to spool the contents of this file to create a .lst file..

as of now, i am giving it like -

sql.sql : spool on
select STATEMENT
spool off

and connecting to sqlplus as sqlplus -s user/pass@db @sql.sql > outputsql

i am getting the query output properly.. but donno how to spool

thanks
Krips.

hi,

after connecting to sqlplus i will be getting the output in a file say test. if i want to spool the contents of this file, what is the syntax of the spool command that i should use..

its an urgent issue.. please help me..

thanks,

Krips.

the correct syntax is:
SQL > spool /tmp/resultfile.txt
*** from now, all output will be saved in /tmp/resultfile.txt ***
SQL > ....sql statement ...
SQL > spool off

I suppose this is rather an oracle question, though.

hi andom,

thanks for replying.. actually i am connecting sqlplus from a shell script..i will be writing the sql queries onto a .sql file and will be given as input to sqlplus...

i tried the spool command as you said..

sql.sql file will be having -

spool \tmp\resultfile.lst
select STATEMENT
spool off;
exit

sqlplus -s user/pass@db @sql.sql

what i am expecting is to get the spooled .lst output of this select query..
what i know is that if i am spooling some file, then i will be getting a .lst file as the output.. if i am wrong then correct me please..

but after exiting from the sqlplus i cant find this resultfile in the tmp directory ! ..i want to use that file ..

can anyone help me...

thanks,

Krips.

hi andom...

am sorry that i said that the command is not working.. actually the mistake was with me... ! .. it ran fine when i corrected that mistake...

thanks a lot....

also, can you answer one more doubt that i have.. will this spool command always create a .lst file... i am said by some one that this spool output will always be a .lst file.. is that so?

thanks a lot..
Krips.