Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.


Chapter 7 Cases : wait

wait
The wait table holds information about each outstanding wait on the system.
Structure
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) ,
expression VARCHAR(200) ,
type SMALLINT NOT NULL)
Wait type. Currently the only supported type is a Step wait (1), that is, the step is waiting for one or more other steps to be released.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following indexes are defined for this table.
Table Activity
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.
Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.