Is it possible to deactivate the display of "Row affected"

Hi,

I would like to know if it is possible to dynamically deactivate the display of the messages like n Row affected ?

In fact, I store in a log file all the information thanks the option -o of isql but because I use variables and I set them with a SELECT statement I have extra "Row affected" I don't want to see.

Any ideas ?
LVL 1
Richard Coffree-commerce Product ManagerAsked:
Who is Participating?
 
amitpagarwalConnect With a Mentor Commented:
or you can even follow another appraoch

cat LOGFILE | grep -v "Row affected" > NEWLOGFILE
mv NEWLOGFILE LOGFILE
0
 
amitpagarwalCommented:

set nocount on
0
 
Richard Coffree-commerce Product ManagerAuthor Commented:
Thanks a lot and especially for the other approach.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.