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