Sybase Question:
Download Questions PDF

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
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.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
Can I use a named pipe to bcp/dump data out or in in Sybase?How do I pipe the output of one isql to another?