Re: COUNT (*)
Im Artikel <347B1FBC.6D29@cobe.com>, Edward Bidinotto <edbid@cobe.com>
schreibt:
>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?
>
Try this:
1.
isql dbname 2>/dev/null <<!
But, if there occurs any error, you can't get the errornumbers.
2.
_selectCount()
{
isql dbname <<!
.
.
.
}
_selectCount 2>&1 | sed '/row(s) retrived/d'
greetings volker