iSQL output file - getting rid of [end of job] comment

[tbrock03]

When I run this SQL to a text file, it prints out fine, but contains a End of Job Successful [or something similar] at the bottom of my text file. Is there any way to get rid of this?

I am using Sybase.

 

[dbtech]

Try this SET NOCOUNT ON, Put this line before you process the sql statement.

Ex
SET NOCOUNTON
SELECT * FROM tablename

dbtech

 

[tbrock03]

I've tried adding this line
Set nocount on
to my sql but I still receive

(Return Status = 0)

at the bottom of my output file.

 

[tbrock03]

Maybe I am adding the set nocount on line in the wrong place. Do i add it to my sql script or on the isql command line?

My sql is>>

declare cursor a_csr for
Select
....
go