SYSKEYCOLUSE catalog table

The SYSKEYCOLUSE table contains a row for every column in a unique constraint (primary key or unique key) from the SYSIBM.SYSTABCONST table. The schema is SYSIBM.

Table 1. SYSIBM.SYSKEYCOLUSE table column descriptions
Column name Data type Description Use
CONSTNAME
VARCHAR(128)
NOT NULL
 Name of the constraint. G
TBCREATOR
VARCHAR(128)
NOT NULL
 Schema or qualifier of the table on which the constraint is defined. G
TBNAME
VARCHAR(128)
NOT NULL
 Name of the table on which the constraint is defined. G
COLNAME
VARCHAR(128)
NOT NULL
 Name of the column G
COLSEQ
SMALLINT
NOT NULL
 Numeric position of the column in the key (the first position in the key is 1). G
COLNO
SMALLINT
NOT NULL
 Numeric position of the column in the table on which the constraint is defined. G
IBMREQD
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
PERIOD
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates whether the column is the start or end column for the BUSINESS_TIME period:
B
The column is the start of the period BUSINESS_TIME.
C
Start of changeColumn is the end of period BUSINESS_TIME with an exclusive end point.End of change
Start of changeIEnd of change
Start of changeColumn is the end of period BUSINESS_TIME with an inclusive end point.End of change
blank
Column is not used as either the start or the end of a BUSINESS_TIME period.
 G