Re: SQL Query Output
Posted in 1998
you seems running it using crontab. You can redirect the stderr to /dev/n=
ull
-----Original Message-----
From: Peter.Lancashire.PL1@bayer.co.uk <Peter.Lancashire.PL1@bayer.co.uk>
To: Sui <Sui>
Date: Tuesday, March 31, 1998 02:48 =D5
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 nocoun=
t
on"
>> which just generates a syntax error.
>>
>> Any help gratefully received.
>>
>> Nik Gilbert (nik.k.gilbert@aexp.com)
>>
>> -----=3D=3D Posted via Deja News, The Leader in Internet Discussion =3D=
=3D-----
>> http://www.dejanews.com/ Now offering spam-free web-based newsreadin=
g
>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/
>