How to select and put into a file

wkraatz@csc.com · *nix forums addict Joined: 08 Jun 2005 Posts: 52

the '-e' command line parameter will echo the SQL statements into the
output a '-o <filename>' parameter will then write both the SQL and
results into the same file.

It might help if you review the Utility Manual section on isql.

http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/utility/@Generic__BookView
Maria wrote:

Maria · *nix forums beginner Joined: 17 Jun 2005 Posts: 11

How can I put my select statement together with the output into a file ?
For example
isql -Uuser -Ppass -Sservername

select * from mytable
go
then the output from this and the select into a file ?
Thanks
Maria

Google