Re: quiet mode for dbaccess?
Posted in 1998
On Wed, 26 Aug 1998 c_l_h@my-dejanews.com wrote:
> Are there any options to dbaccess that make it "quiet"? That is, that don't
> echo "Database selected." "Database closed." "10 rows selected." when I do
> this from the unix prompt:
>
> % echo "select * from table1" | dbaccess db1>
> I use 7.22.uc1 on Solaris 2.5.1
No.
You can get a limited amount of quietness by redirecting standard error to
/dev/null, but only if you use a civilized shell (meaning Bourne shell,
Korn shell or Bash, and (probably) not C shell which you're probably using
given the % prompt in your example).
If you really want a cleaner interface, go an dig out the SQLCMD program
from the IIUG archives -- http://www.iiug.org. This is a biassed
recommendation; I wrote it. It does require ESQL/C on your machine.
Yours,
Jonathan Leffler (jleffler@informix.com) #include <witticism.h>
Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN
Informix IDN for D4GL & Linux -- http://www.informix.com/idn