Re: Is there a way to make dbaccess shut up?
In article <4v2oou$q0n@cesium.norand.com>, Robert Walters <walterba@norand.com> wrote:
>I'm working on a shell script (HP-UX & V7.2) and when I pipe
>a query to dbaccess, I can't seem to turn off the messages
>about connecting and disconnecting.
>
>Is this possible.
>
>For example:
>
>echo " select t.tabname from systables t, sysdepend d
> where t.tabid = d.dtabid
> and d.dtype = 'V'
> and d.btabid = (
> select tabid from systables
> where tabname = '$2')" |
> dbaccess $1 > x.out>
>gives me a list of tables in x.out, but I get this junk
>on the screen
> (snip, snip)
For some strange reason, dbaccess (at least version 5.x) sends the "connected,
row retrieved", etc. messages to stderr. Include a "2> /dev/null" on the end
of your command.
Brad Green
Director of Product Development
Eden Systems, Inc.
brad@edeninc.com
Views expressed herein are my own, unless my superiors agree
with me (at which point, they will no doubt take the credit)