select char(tm.name, 16) "tb", mult, decimal(cardf, 15) "runStatsCardF"
from tm
where dbname $DBIN
order by tm.name
;
select dbName, type, count(*)
from sysIbm.sysTables
where dbName $DBIN
group by dbName, type
order by dbName
;
select char(strip(creator) || '.' || strip(name), 20) "cr.tb",
char(strip(dbName) || '.' || strip(tsName), 17) "db.ts",
statstime, cardf
from sysIbm.sysTables
where type = 'T' and dbName $DBIN
order by statstime
;