Output to a file from sybase stored procedure ?

[sushanth04]

Hi

I need to query data from a couple of tables and write the result sets into a file using a stored procedure.I am new to sybase.Please help.

Regards
Sushanth.B

 

[Massy]

Have you tried the "output to" command?

Tom.

 

[dickiebird]

What O/S is this on ?
If unix, then you could call a procedure from a script
eg :
isql -U${DBUSER} -P${DBPASS} -S${SRV}<<-EOF > /tmp/lc_rts1
select * from RTSSchemeTable
go
EOF

and file /tmp/lc_rts1 will have the output in it.
HTH

Dickie Bird (-)))