DB2 Metadados

listar tabelas do DB2 pelo nome e schema
1
2
3
4
select * from sysibm.systables
where owner = 'SCHEMA'
and name like '%CUR%'
and type = 'T';
listar colunas pelo nome e tabela
1
2
3
4
5
6
7
8
select * from sysibm.syscolumns LIMIT 100;


SELECT * FROM "SYSIBM".SYSCOLUMNS a 
       WHERE 
        A.TBCREATOR IN ('DB2MCO') 
        -- AND a.TBNAME IN ('PRPT_SRVC_CTRD', 'TCOP183', 'TCOP117', 'TCOP117')
        AND (a.NAME LIKE '%COD_ORIG_RECU%');