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.
If you include an = with an iteration number after a sequence name a JSON list of will be returned. For example: [1078,1079,1080]
Example input list:
SupplierID,ProductID=3,SYSDATETIME()

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

Master File Controller

XML Create Template