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

FREE TUTORIALS

Tutorials
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.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others