Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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)

Column | Description
`seq_id` | Sequence ID of the associated `seq_val` value. One of the following values: `1` (o_reqid) `2` (casenum) `3` (proc_id) `4` (wait_id) `5` (def_id) `6` (cfg_id)
`seq_val` | Current sequence number value for the sequence defined by `seq_id`.
`seq_name` | Name of the associated `seq_id` column. One of the following values: `REQID` `CNUM` `PROC` `WAIT` `CDQP_DEF` `CDQP` 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.

Index Name | Column(s) Indexed
`idx_sequence` `s` | `seq_id`

## 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.

A row is... | When...
added | never.
updated | when a new sequence number of that type is requested.
deleted | never.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine