The HSSYSREL table is used for SYSRELS views. The following table describes the columns in the HSSYSREL table:
Column | Type | Length | Decimal | Domain |
---|---|---|---|---|
CREATOR | VARCHAR | 128 | 0 | The schema of the dependent table of the referential constraint |
TBNAME | VARCHAR | 128 | 0 | Name of the dependent table of the referential constraint |
RELNAME | VARCHAR | 128 | 0 | Constraint name |
REFTBNAME | VARCHAR | 128 | 0 | Name of the parent table of the referential constraint |
REFTBCREATOR | VARCHAR | 128 | 0 | The schema of the parent table |
COLCOUNT | SMALLINT | 4 | 0 | Number of columns in the foreign key |
DELETERULE | CHAR | 1 | 0 | Type of delete rule for the referential constraint |
IBMREQD | CHAR | 1 | 0 | |
RELOBID1 | SMALLINT | 4 | 0 | Internal identifier of the constraint with respect to the database that contains the parent table |
RELOBID2 | SMALLINT | 4 | 0 | Internal identifier of the constraint with respect to the database that contains the parent table |
TIMESTAMP | TIMESTAMP | 26 | 0 | Date and time the constraint was defined |
IXOWNER | VARCHAR | 128 | 0 | The schema of unique non-primary index used for the parent key |
IXNAME | VARCHAR | 128 | 0 | Name of unique non-primary index used for a parent key |