Solved

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

Posted on 2001-07-24
3
273 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ORCA Powerbuilder import 7 1,078
Looking for Sybase 12.5.4 EBF ESD#9.1 or 10 patch 5 782
Sybase - sp_cacheconfig 1 965
Problems writing binary files to Sybase from PHP 2 179
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Fine Tune your automatic Updates for Ubuntu / Debian
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

910 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

24 Experts available now in Live!

Get 1:1 Help Now