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 number(10) NOT NULL,
node_id number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
parentstep varchar2(8) NULL,
expression varchar2(200) NULL,
type number(1) 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.
Storage
The following STORAGE values 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