Sybase Question: Download Questions PDF
How to remove row affected and dashes?
Answer:
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.
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.
Download Sybase Interview Questions And Answers
PDF
| Previous Question | Next 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? |