CHKARRANG

This table associates the defined store commands (SCHCMD) with the defined check commands (CHKCMD).

Column Descriptions:

NameTypeDescription
CHKCMD_IDINTEGER NOT NULLThe unique identifier of the check command.
SCHCMD_IDBIGINT NOT NULLThe unique identifier of the store scheduler command.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CHKCMD_ID+SCHCMD_IDPrimary Key
I0000533SCHCMD_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_234CHKCMD_IDCHKCMDCHKCMD_IDCascade
F_235SCHCMD_IDSCHCMDSCHCMD_IDCascade