SYSIBM.SYSKEYCOLUSE table

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

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 came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.

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

 G
Start of changePERIODEnd of change Start of change
CHAR(1)
NOT NULL WITH
DEFAULT
End of change		 Start of changeIndicates 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
Column is the end of period BUSINESS_TIME.
blank
Column is not used as either the start or the end of a BUSINESS_TIME period.
End of change		 Start of changeGEnd of change