zOs/SQL/CATRI

select *
    from sysibm.sysForeignKeys
    where relname = 'DP091$UU'
    order by colno, tbName
;
-- Relationen anzeigen
--
select char(relname, 12),
       char(strip(creator) ||'.'|| strip(tbName), 20) "child",
       char(strip(refTbCreator)||'.'||strip(refTbName), 20) "in parent",
       case when deleteRule = 'A' then 'no action'
            when deleteRule = 'C' then 'cascade'
            when deleteRule = 'N' then 'set null'
            when deleteRule = 'R' then 'restrict'
            else                       'rule ' || deleteRule end
    from sysibm.sysRels
    where (creator like 'OA1%' and tbName like 'TDP%' )
       or (refTbCreator like 'OA1%' and refTbName like 'TDP%' )
    order by 2
;
select *
    from sysIbm.sysForeignKeys
    where relName = 'XR101$RE'
;