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/