Description: Contains one row for every column of every foreign key.
Tablespace: SYSDBASE
Indexes(Fields):
DSNDRH01(CREATOR.TBNAME.RELNAME)
| Column name | Description | Data type |
|---|---|---|
| CREATOR | Authorization ID of the owner of the table that contains the column. | NOT NULL |
| TBNAME | Name of the table that contains the column. | NOT NULL |
| RELNAME | Constraint name for the constraint for which the column is part of the foreign key. | NOT NULL |
| COLNAME | Name of the column. | NOT NULL |
| COLNO | Numeric place of the column in its table. | NOT NULL |
| COLSEQ | Numeric place of the column in the foreign key. | 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).