The wait table holds information about each outstanding wait on the system.
The wait table has the following structure:
TABLE wait (
wait_id NUMERIC(10) NOT NULL,
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
parentstep VARCHAR(8) NULL,
expression VARCHAR(200) NULL,
type SMALLINT NOT NULL)
The following DELETE CASCADE trigger is defined for this table.
The wait table contains one row for each outstanding wait on the system. An associated record exists in the
wait_step table for each step being waited for.