CREATE SET TABLE workforce.department
, FALLBACK
, NO BEFORE JOURNAL
, NO AFTER JOURNAL
, CHECKSUM = DEFAULT
, DEFAULT MERGEBLOCKRATIO
(
DeptNo SMALLINT
FORMAT '999'
CHECK ( (DeptNo >= 100 ) AND (DeptNo <= 900 ) )
NOT NULL
, DeptName VARCHAR(14)
CHARACTER SET LATIN NOT CASESPECIFIC
, Loc CHAR(3)
CHARACTER SET LATIN NOT CASESPECIFIC
, MgrNo SMALLINT
FORMAT '9(5)'
CHECK ( (MgrNo >= 10001 ) AND (MgrNo <= 32001 ) )
NOT NULL
)
UNIQUE PRIMARY INDEX ( DeptNo )
;