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