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