zOs/SQL/CATALL

select 'rz1.dbaf', 'd', name, '', '', ''
    from sysibm.sysDatabase where name like 'NI%'
union all select 'rz1.dbaf', 't', dbname, tsName, creator, name
    from sysibm.sysTables where dbName like 'NI%' and type = 'T'
union all select 'rz1.dbaf', 'x', tbCreator, tbName, creator, name
    from sysibm.sysIndexes where dbName like 'NI%'
union all select 'rz1.dbaf', 'v', dbname, tsName, creator, name
    from sysibm.sysTables
        where type = 'V' and (dbName like 'NI%' and name like 'VNI%')
union all select 'rz1.dbaf', 'a', tbCreator, tbName, creator, name
    from sysibm.sysTables
        where type = 'A' and (dbName like 'NI%' and name like '_NI%')