Pular para conteúdo

Home

  • 1 min de leitura

Setando proxy no npm

1
2
npm config set proxy "http://usuario:12345678@127.0.0.1:40080"
npm config set https-proxy "http://usuario:12345678@127.0.0.1:40080"
  • 1 min de leitura

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%');