For example I have created one query to get Primary Key Constraints , like this I need quries for mentioned above containts.
SELECT SUBSTR(A.TBNAME,1,20) AS "TABLE NAME",
SUBSTR(A.COLNAME,1,20) AS "COLUMN NAME",
SUBSTR(A.RELNAME,1,20) AS "RELATION NAME"
FROM SYSIBM.SYSFOREIGNKEYS A, SYSIBM.SYSRELS B
WHERE A.TBNAME= B.REFTBNAME;
Satyaram : Initially I forgot to give my installation info that's why I have given this info aftr reading ur post.
I am working on DB2 V8 on mainframe, using Spufi and QMF