Re: Getting list of available databases from dbaccess?
In article , Robert says...
>
>
>Is there a command I pipe into dbaccess that will return a list of all
>available databases on a particular server? I'm looking for something
>similar to the "INFO STATUS" command.
>
>--
>Rob Hale
I use the following script to get the list of databases from a particular
Informix instance (I have Online 5.06 under SCO Open Server 5.02)
tbcheck -pe | awk 'NF == 3 && $1 ~ /:/ { split($1, t, ":"); dbnames[t[1]] }
END { for ( d in dbnames ) print d }'
It has been particulary useful in automated tasks, such as CRON's to check
indexes.
Hope this helps...
-----
Juan Manuel De Villeros
jmdv@usa.net