Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Sequence Numbers : sequences

sequences
The sequences table is used to generate unique sequence numbers for the use of TIBCO iProcess Engine server processes.
Structure
The sequences table has the following structure:
TABLE sequences (
seq_id INTEGER NOT NULL,
seq_val NUMERIC(20) NOT NULL,
seq_name VARCHAR(24) NOT NULL)
Sequence ID of the associated seq_val value. One of the following values:
Name of the associated seq_id column. One of the following values:
Note: This value is not currently used by the iProcess Suite.
Primary Key
None.
Triggers
None.
Indexes
The following clustered index is defined for this table.
Table Activity
This table always contains 6 rows—one row for each type of sequence number used by the iProcess Engine server processes. The table is populated when the iProcess Engine is installed.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved