How to remove row affected and dashes

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to remove row affected and dashes

If you pipe the output of isql then you can use sed(1) to remove this extraneous output:

echo "$PASSWD
sp_who
go" | isql -U sa -S MY_SERVER | sed -e '/affected/d'
-e '/---/d'


If you simply wish to eliminate the row affected line use the set nocount on switch.

(Continued on next question...)

Other Job Interview Questions

• Explain about the Sybase group?
• How do I find the oldest open transaction in Sybase?
• On what platforms is ASA supported?
• How to feed the result set of one stored procedure into another in Sybase ?
• How do I run multiple versions of Sybase on the same server?
• How to swap a db device with another
• What Is Table Partitioning in Sybase ?
• The timestamp datatype in Sybase ?
• How do I configure Identities in Sybase?
• How do I pipe the output of isql to a file in Sybase?
• More...