Re: COUNT (*)
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
===============================================================