Help - how to create a log output, while running a SQL Script?

[sdas123]

How could I create a log output file while I run a SQL Script manually?

 

[sybaseguru]

Unlike Oracle SQL*Plus you cannot use spool command. However, you can create an sql file such as the following:

sybase@linux:/tmp% cat getdate.sql
use master
go
select getdate()
go
exit

and run it as

sybase@linux:/tmp%  isql -Usa -w1000 -i getdate.sql -o getdate.log
Password:
sybase@linux:/tmp% more getdate.log

 --------------------------
        Jun 23 2003  9:46PM

(1 row affected)

-i refers to the input file and -o refers to the output filename
Hope this helps

 

[markmar1]

If you want to see all the actual SQL executed, with the results afterwards, use the '-e' option from isql. It will echo all the sql commands, and then execute the sql.

good luck...