zOs/SQL/CONSTDEP
select * from sysibm.syschecks c, sysibm.systables t
where c.tbowner = t.creator and c.tbname = t.name
and
(t.dbname like 'BJAA_0001'
or t.dbname = 'DBJ01' or t.dbname like 'DNF%')
;
x
select
char(strip(c.bSchema) ||'.'|| strip(c.bName), 20) "b",
char(strip(dTbcreator) ||'.'|| strip(dTbName), 20) "d",
char(dConstName, 30)
from sysibm.sysConstDep c-- , sysIbm.sysTables t
-- where
-- (t.name = c.bName or t.name = c.dTbName)
-- and
-- (t.dbname like 'BJAA_0001'
-- or t.dbname = 'DBJ01' or t.dbname like 'DNF%')