Description: Contains one row for every referential constraint.
Tablespace: SYSDBASE
Indexes(Fields):
DSNDLX01(REFTBCREATOR.REFTBNAME)
DSNDLX02(CREATOR.TBNAME)
| Column name | Description | Data type |
|---|---|---|
| CREATOR | Authorization ID of the owner of the dependent table of the referential constraint. | NOT NULL |
| TBNAME | Name of the dependent table of the referential constraint. | NOT NULL |
| RELNAME | Constraint name. | NOT NULL |
| REFTBNAME | Name of the parent table of the referential constraint. | NOT NULL |
| REFTBCREATOR | Authorization ID of the owner of the parent table. | NOT NULL |
| COLCOUNT | Number of columns in the foreign key. | NOT NULL |
| DELETERULE | Type of delete rule for the referential constraint: ; A
|
NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| RELOBID1 | Internal identifier of the constraint with respect to the database that contains the parent table. | NOT NULL WITH DEFAULT |
| RELOBID2 | Internal identifier of the constraint with respect to the database that contains the dependent table. | NOT NULL WITH DEFAULT |
| TIMESTAMP | Date and time the constraint was defined. If the constraint is between catalog tables prior to DB2 Version 2 Release 3, the value is '1985-04-01-00.00.00.000000.'. | NOT NULL WITH DEFAULT |
| IXOWNER | Owner of unique non-primary index used for the parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index. | NOT NULL WITH DEFAULT |
| IXNAME | Name of unique non-primary index used for a parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index. | NOT NULL WITH DEFAULT |
| ENFORCED | Enforced by the system or not: ; Y
|
NOT NULL WITH DEFAULT 'Y" |
| CHECKEXISTINGDATA | Option for checking existing data: ; I
|
NOT NULL WITH DEFAULT |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).