Re: SQL Query Output

Posted in 1998

Michal Hajek — Thu, 26 Mar 1998 14:44:59 +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. Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------