Re: COUNT (*)

Posted in 1997

Robert Messer — 26 Nov 97 13:23:14 GMT — source: Informix-list mailing list archive (1991-1998)

Edward Bidinotto <edbid@cobe.com> schrieb im Beitrag <347B1FBC.6D29@cobe.com>... > 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? The 1 row retrieved is always sent to stderr. You could easily eliminate it by redirecting stderr to /dev/null: "isql dbname xxx.sql 2> /dev/null" > > Tks > Ed > > edbid @ cobe.com > Robert