Re: COUNT (*)

A different approach would be rely on the fact that much of Informix' output that is "noise" is actually going to STDERR. When using ksh, the command would look like the following: isql DBNAME < some_script.sql 2>/dev/null Caveat: you miss your error messages, so try isql DBNAME < some_script.sql |grep 'error' instead. -d At 07:18 PM 11/26/97 +0000, Rob Prop wrote: }Edward Bidinotto wrote: }> }> To all" }> }> When you do }> }> isql dbname <<! }> }> select count(*) from table }> ! }> }> it comes back with the count and also }> }> 1 row(s) retrieved. }> }> Is there any way to eliminate the 1 row retrieved within a script? }> }> Tks }> Ed }> }> edbid @ cobe.com } }Hi, } }I think this is very simple in UNIX, just pipe the output from your }command to "grep -v 'retrieved'". On many platforms this should works !! } }Kind regards, } Rob Prop } }-- } =============================================================== } Rob Prop Tel. : +31-164-255300 } Consultant Fax. : +31-164-246162 } Informa Automatisering bv Email: rprop@concepts.nl } Bergen op Zoom informa@pi.net } The Netherlands Web : http://www.informa.nl } =============================================================== } }