123456789101112 |
- for dbname in `echo "select name from sysdatabases where name not in ('sysmaster','sysuser','sysutils','sysadmin');"|dbaccess sysmaster - 2>/dev/null |awk '{print $2}'`
- do
- echo "DB NAME = "$dbname
- echo "select
- unique(strategy)
- from
- sysfragments
- where
- fragtype = 'T'
- and tabid > 99 ;"|dbaccess $dbname
- done
|