Re: How to hide the output from echo "select..."|dbaccess sysmaster?
Posted in 1999
Couple of ways
1. use unload command like
BOTTLEIT="unload to "/tmp/xx" select name from sysdatabses"
dbaccess sysmaster -<<EOF
$BOTTLEIT
EOF
2. Try with "output to file|pipe without heading"
Sanjeev K. Sagar
--- san <san@inist.ru> wrote:
>
> Huy Vu <huyv@usa.net> wrote in message
> news:E6YO2.75711$Mb.30683722@newscontent-02.sprint.ca...
> > Hi all,
> >
> > I'm trying to hide some output displayed from the
> unix command below for
> > example:
> >
> > echo "select name from sysdatabase"|dbaccess
> sysmaster|grep eagle
> >
> > Open database... <--------- would like
> to hide
> >
> > eagle
> >
> > 22 row(s) .... <--------- would
> like to hide
> >
> > Close database.. <--------- would like to
> hide
> >
> > I tried to redirect the output to /dev/null 2>&1
> but not successful.
> >
> > Thank you in advance for any idea.
> >
> > H.V
> >
> >
>
> try use awk command to process output from dbaccess
>
> Svikhnushin Andrew
> Inist Ltd
> san@inist.ru
>
>
>
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com