Re: COUNT (*)

Posted in 1997

Williamson — 26 Dec 1997 12:00:36 GMT — source: Informix-list mailing list archive (1991-1998)

The way I do it (SCO UNIX, Informix 4.10) is to pipe the script output through "grep" to get rid of unwanted lines, e.g. [preferred commands to execute script here] | grep -v retrieved | grep . ^ ^ |remove lines |&remove blank lines |with "retrieved" Edward Bidinotto <edbid@cobe.com> wrote in article <347B1FBC.6D29@cobe.com>... > To all" > > When you do > isql dbname <<! cut... > it comes back with the count and also > 1 row(s) retrieved.