| 12345678910111213 |
- 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
- coltype, count(coltype)
- from
- syscolumns
- where
- tabid > 99
- and coltype in (11,12,14,15,16,19,20,21,22,40,4118)
- group by 1;"|dbaccess $dbname
- done
|
