Description: Contains a row for every column in a unique constraint (primary key or unique key) from the SYSIBM.SYSTABCONST table.
Tablespace: SYSOBJ
Indexes(Fields):
DSNCUX01(TBCREATOR.TBNAME.CONSTNAME.COLSEQ.)
| Column name | Description | Data type |
|---|---|---|
| CONSTNAME | Name of the constraint. | NOT NULL |
| TBCREATOR | Authorization ID of the owner of the table on which the constraint is defined. | NOT NULL |
| TBNAME | Name of the table on which the constraint is defined. | NOT NULL |
| COLNAME | Name of the column | NOT NULL |
| COLSEQ | Numeric position of the column in the key (the first position in the key is 1). | NOT NULL |
| COLNO | Numeric position of the column in the table on which the constraint is defined. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL WITH DEFAULT 'N' |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).