Re: COUNT (*)

Robert Messer wrote: > > 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" Or more directly to the original example: isql dbname <<! 2>/dev/null select count(*) from table! //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 6300 S Syracuse Way Ste 205 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-779-4025 and do not necessarily //////////////// http://www.informix.com reflect those of my employer