SQL data to a file

[ssphoenix]

I have several records that needs to be appended to a file from a sql database. So far the script runs but only for the first record. I have on line that says

OUTPUT_TO my_file.txt

SELECT number from_master_file WHERE .... etc
SELECT number from_master_file WHERE ...some more etc.

How can I get the data I am getting from these sql statements appended to a file?

I also need to put some banners between these records. Tryed banner and tried echo commands. For some reason it didn't like it.

Help would be greatly appreciated.

Thanks

 

[olded]

Hi:

This really depends on the database you're using - Oracle, Informix, etc.

There's probably a Tek-tips forum that can help, but this isn't really the place.

Regards,


Ed