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
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


Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others