SYSCHKCST

The SYSCHKCST view contains one row for each check constraint in the SQL schema. The following table describes the columns in the SYSCHKCST view.

Table 1. SYSCHKCST view
Column Name System Column Name Data Type Description
CONSTRAINT_SCHEMA DBNAME VARCHAR(128) Name of the schema containing the constraint.
CONSTRAINT_NAME RELNAME VARCHAR(128) Name of the constraint
CHECK_CLAUSE CHECK VARGRAPHIC(2000) CCSID 1200
Nullable
 Text of the check constraint clause

Contains the null value if the check clause cannot be expressed without truncation.
ROUNDING_MODE DECFLTRND CHAR(1)
Nullable
 The rounding mode for the check constraint:
C
ROUND_CEILING
D
ROUND_DOWN
F
ROUND_FLOOR
G
ROUND_HALF_DOWN
E
ROUND_HALF_EVEN
H
ROUND_HALF_UP
U
ROUND_UP
SYSTEM_CONSTRAINT_SCHEMA SYS_CDNAME CHAR(10) Name of the system schema containing the constraint.
Start of changeINSERT_ACTIONEnd of change Start of changeINS_ACTIONEnd of change Start of changeVARGRAPHIC(500) CCSID 1200
Nullable
End of change		 Start of changeIf an insert violation action has been defined, contains the text of the ON INSERT clause. Otherwise, contains the null value.End of change
Start of changeUPDATE_ACTIONEnd of change Start of changeUPD_ACTIONEnd of change Start of changeVARGRAPHIC(500) CCSID 1200
Nullable
End of change		 Start of changeIf an update violation action has been defined, contains the text of the ON UPDATE clause. Otherwise, contains the null value.End of change