How to check constraints for DB2 table in mainframe

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
gsb198926
Member
Posts: 2
Joined: Tue Jul 18, 2017 2:18 pm

How to check constraints for DB2 table in mainframe

Post by gsb198926 » Thu Jul 27, 2017 7:38 pm

Hello everyone,
Need help regarding constraints and checks for a DB2 table
How can we find out what constraints are defined on a Table ?
we can see index and column information in SYSIBM.SYSCOLUMNS and SYSIBM.SYSINDEXES but is there any way we can get the constraints for the table


Thanks

Post Reply