how to list all databases?
Posted in 1997
Heckers — — source: Informix-list mailing list archive (1991-1998)
We used to write an esql/c program to do an
update statistics medium every night.But we have to support a lot of different platforms
now and so I wrote a ksh-script, that does the
same job.
I use oncheck -pc to get a list of all all databases
and use this list to do an update statistics with
dbaccess.
But oncheck is very slow!
Who knows a faster method, I don't know much about the
system tables, but maybe there is a better method using
dbschema etc..
Should be something like
<command> |grep [-v ] xxx | awk '{print $i}'
or
dbaccess <<EOF
SQL-COMMANDS
EOF
Thankx,
Erik