zOs/SQL/PROTPTA

with tb as
( select *
    from sysibm.sysTables
    where (dbName like 'AV%' or dbName like 'VV%' or dbName like 'NI%'
         or name like 'VAV%' or name like 'VVV%' or name like 'VNI%')
)
select type, strip(creator) || '.' || strip(name)
    from tb
union all select 'i', strip(creator) || '.' || strip(name)
            || ' on ' || strip(tbcreator) || '.' || strip(tbname)
    from sysibm.sysIndexes
    where (dbName like 'AV%' or dbName like 'VV%' or dbName like 'NI%'
         or name like 'IAV%' or name like 'IVV%' or name like 'INI%')
union all select 'r', strip(Creator) || '.' || strip(tbName)
            || ' ref ' || strip(reftbcreator) || '.' || strip(reftbname)
            || ' ' || strip(char(colCount)) || ' ' || relName
    from sysibm.sysRels
    where (Creator, tbName) in (select creator, name from tb)
       or (refTbCreator, refTbName) in (select creator, name from tb)
union all select 'j', strip(schema) || '.' || strip(Name)
            || ' Trigger ' || trigTime || trigEvent || granularity
            || ' ' || strip(tbowner) || '.' || strip(tbName)
    from sysibm.sysTriggers
    where (tbowner, tbName) in (select creator, name from tb)
    order by 2, 1
$#out                                              20120416 07:13:13
C COL2
T A230450.VNI145TOCLOSE
T A230450.VNI145TODEL