Re: SQL Query Output
Posted in 1998
Just redirect the standard output to /dev/null.
dbaccess database filename 1>/dev/null 2>&1
This will redirect all Informix and system messages to /dev/null.
Nick Leporacci
nik.k.gilbert@aexp.com wrote in message <6f8g8d$2f$1@nnrp1.dejanews.com>...
>Help ! I'm using dbaccess via a Unix c-shell and all the data is being
>retrieved OK. However, each query results in a "x row(s) retrieved message"
>which I can't stop or redirect anywhere which results in hundreds of
unwanted
>e-mails.
>
>Does anyone know how to turn this off ? (Someone suggested "set nocount on"
>which just generates a syntax error.
>
>Any help gratefully received.
>
>Nik Gilbert (nik.k.gilbert@aexp.com)
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading