Get Sequences
This component will return a unique sequence number or timestamp.You can return multiple sequences in one go and, in addition return multiple results for one sequence.
The component can also return timestamps
The component uses a connection to a back end SQL Server or Azure database to maintain the sequences, you can use SQL Manager to manage these sequences.
Flow Location
C:\VIPTDM\GetSequences\GetSequences.vip
Submit through Executor Form
No
Use as part of models and TDA
Yes
Used in Solutions
Message Management – using a modelled csv
Operation
A single call will connect to a back end database and return the sequence and timestamp results.
Parameters
Parameter | Description | Internal |
parSequenceName | The names of the sequences are separated by a comma. If a sequence name does not exist a sequence will be created and will start returning from 1. | N |
parConnectionString | The Azure database connection string | Y |
Output Data
The data will be returned in the parOutData list string with each sequence separated by —
How to use the component
In the following example, we have given the component a list of sequence names.

When the component is run the values are assigned to variables. These output variables can be assigned as input to other components.

The returned sequence variables are defined in the output parameters

The variables become inputs to other components. In this case we are assigning variables into the component Generate CSV
TEST MODELLER SOLUTIONS AND COMPONENTS COMPONENTS