Piping Results to a file

[Debbie]

I have a shell script in UNIX that has a Oracle SQL command. What I would
like to do is pipe the results of the query to a separate file. What is
the command I use?

Note, I ran the shell script from the command line and it pipes out to the
file, but somehow it won't do it is I place the command into a shell script
and initial the command.

Can anyone help me out?

[Debbie]

I got my question answered for anyone who might be wondering how this is done.
The command is: spool <filename>. It creates the file with a .lst extension.
Once done, you must run: spool off.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

"Debbie" <dremig@melloninvestor.com> wrote:
>
>I have a shell script in UNIX that has a Oracle SQL command. What I would
>like to do is pipe the results of the query to a separate file. What is
>the command I use?
>
>Note, I ran the shell script from the command line and it pipes out to the
>file, but somehow it won't do it is I place the command into a shell script
>and initial the command.
>
>Can anyone help me out?