Add Sequence
Description
Add sequence is a step in the Transform Plugin for Process Studio Workflows. The Add sequence step adds a sequence to the stream. A sequence is an ever -changing integer value with a specific start, increment and maximum value. You may use a database to generate the sequence or use a workflow counter in Process Studio to generate the sequence.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of this step as it appears in the workflow workspace. This name must be unique within a single workflow. |
| 2 | Name of value | Specify the name of the new sequence value that is added to the stream. |
| 3 | Use DB to generate the sequence | Enable if you want the sequence to be driven by a database sequence, then set these parameters: Connection name, Schema name (optional), Sequence name. |
| 4 | Connection name | Specify the name of the connection on which the database sequence resides. |
| 5 | Schema name (optional) | Specify the table's schema name. |
| 6 | Sequence name | Specify the name of the database sequence. |
| 7 | Use a workflow counter to generate the sequence | Enable if you want the sequence to be generated by Process Studio, and then set these parameters: Counter name (optional), Start at, Increment by, Maximum value. |
| 8 | Counter name (optional) | If multiple steps in a workflow generate the same value name, this option enables you to specify the name of the counter to associate with. Avoids forcing unique sequencing across multiple steps. |
| 9 | Start at | Specify the value to begin the sequence with. |
| 10 | Increment by | Specify the amount/number by which the sequence increases or decreases. |
| 11 | Maximum value | Specify the value after which the sequence returns to the Start At value. |