frag_strat.sh 323 B

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