Suppression of "(n rows affected)"

[Dusky]

How do I prevent the above appearing at the end of my report in Sybase ? I know I can pass the output to "awk", & remove it there, but is this the only approach ?
Many thanks.

 

[tlbroadbent]

Use "set nocount on" Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm