db2 useful SQL

 connect to DBXXX user XXX using Password

disconnect xxxx

describe select * from sysibm.systables 

show all tables:

list tables for schema XXX

select schemaname from syscat.schemata

describe table db2_inst.employee    
DESCRIBE SELECT * FROM jjjj

--select constname, tabname, type from syscat.tabconst
--describe table syscat.tabconst
select * from syscat.tabconst

--select * from syscat.tabconst where tabschema='ly'

select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references