Answers

Question and Answer:

  Home  Sybase

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

 137 views

More Questions for you: