Solved

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

Posted on 2001-07-24
3
272 Views
Last Modified: 2006-11-17
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 ?
0
Comment
Question by:Richard Coffre
  • 2
3 Comments
 
LVL 5

Expert Comment

by:amitpagarwal
ID: 6313487

set nocount on
0
 
LVL 5

Accepted Solution

by:
amitpagarwal earned 50 total points
ID: 6313525
or you can even follow another appraoch

cat LOGFILE | grep -v "Row affected" > NEWLOGFILE
mv NEWLOGFILE LOGFILE
0
 
LVL 1

Author Comment

by:Richard Coffre
ID: 6316316
Thanks a lot and especially for the other approach.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
In  today’s increasingly digital world, managed service providers (MSPs) fight for their customers’ attention, looking for ways to make them stay and purchase more services. One way to encourage that behavior is to develop a dependable brand of prod…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now