Description: Contains one row for each table check constraint for catalog |tables created in or after Version 7. Check constraints for catalog tables created before Version 7 are not included in this table.
Tablespace: SYSSTR
Indexes(Fields):
DSNCHX01(TBOWNER.TBNAME.CHECKNAME)
| Column name | Description | Data type |
|---|---|---|
| TBOWNER | Authorization ID of the owner of the table on which the check constraint is defined. | NOT NULL |
| TBNAME | Name of the table on which the check constraint is defined. | NOT NULL |
| CHECKNAME | Check constraint name. | NOT NULL |
| PATHSCHEMAS | SQL path at the time the check constraint was created. The path is used to resolve unqualified cast function names that are used in the constraint definition. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).