Re: output-format of select in sysdatabases
If you want it unloaded to a file just prefix the command with "unload to
filename delimiter ' '"
----- Original Message -----
Subject: output-format of select in sysdatabases
Date: Tue, January 8, 2008 13:30
From: "wjb" <w.behnke@uni-bonn.de>
Hello,
>
> I would like to automate the task "show me wether my databases are in
> buffered logging mode".
>
> The command
> echo "select name, is_buff_log from sysdatabases \\
> where name not in ('sysmaster','sysutils','stores_demo', \\
> 'sysuser') order by name;" | dbaccess sysmaster
> returns:
>
> ========================
> Database selected.
>
> name db1
> is_buff_log 1
>
> name db2
> is_buff_log 0
>
> name db3
> is_buff_log 1
>
> 3 row(s) retrieved.
>
> Database closed.
> ========================
>
> Is there a select-option etc. to get the result in this form without
> an awk-call:
>
> db1 1
> db2 0
> db3 1
>
> Thank you
> Werner
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>