Re: SQL Query Output

Posted in 1998

Valery Fouques — Thu, 02 Apr 1998 19:18:46 +0100 — source: Informix-list mailing list archive (1991-1998)

> > 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" > > Does anyone know how to turn this off ? (Someone suggested "set nocount on" > > which just generates a syntax error. > > > I do not know how to turn it off, but I use this principle: > echo "select \\"WHATWHAT\\" ......" | isql dbname | grep WHATWHAT | \\ > cut and_appropriate_parameters_ > > It works without problems. I just use this : echo "output to pipe cat without headings select ......"|dbaccess dbname 2>&-|awk '{ if(NF) print $0 }' Then, we have the rows and ONLY them. Cheers -- Valery Fouques Valery.Fouques@wanadoo.fr SYSADMIN GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' http://perso.wanadoo.fr/valeryf =(_ _)= U