RE: SQL Query Output
I do the same thing using the sh shell and do not have the problem. I
pipe the stderr to /dev/null. I recommend switching to a different
shell then csh.
>----------
>From: Peter Lancashire[SMTP:Peter.Lancashire.PL1@bayer.co.uk]
>Sent: Monday, March 30, 1998 10:58 AM
>To: informix-list@iiug.org
>Subject: Re: SQL Query Output
>
>nik.k.gilbert@aexp.com wrote:
>>
>> Help ! I'm using dbaccess via a Unix c-shell and all the data is being
>> retrieved OK. However, each query results in a "x row(s) retrieved message"
>> which I can't stop or redirect anywhere which results in hundreds of
>>unwanted
>> e-mails.
>>
>> Does anyone know how to turn this off ? (Someone suggested "set nocount on"
>> which just generates a syntax error.
>>
>> Any help gratefully received.
>>
>> Nik Gilbert (nik.k.gilbert@aexp.com)
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>I have a feeling the C shell has trouble redirecting stderr in some
>circumstances. Many folk don't use csh for scripts because of many
>well-known problems. Use sh or ksh or bash.
>--
>Peter Lancashire
>Information Systems Specialist, Bayer plc
>Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
>Tel: +44-1635-562258, Fax: +44-1635-562281
>Mail: Peter.Lancashire.PL1@bayer.co.uk
>---
>My Internet plumbing does not allow me to mail and post news together.
>Sorry.
>All opinions are my own and not those of Bayer plc.
>---
>Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/
>