sequence
Icon |
|
|---|---|
Use When |
A sequence number needs to be created for a given attribute in a model based record, and the starting value of the sequence can be derived by a sql statement. |
Samples |
|
Description |
The sequence component allows an attribute in a model based message to be filled with a generated sequence number. The initial value for the sequence is derived based on a sql statement configured in the component. From that point forward, every new message/record that comes into the component gets an incremented sequence number placed in the designated sequence number attribute field. |
Inbound Message Type |
Model Based Message |
Output Message Type |
Model Based Message |
Control Message Handling |
Input: Entity messages are processed as they are received. Output: A single control message will be forwarded to downstream components once all messages have been processed through this step. |
| Name | Description |
|---|---|
Resource |
The Database Resource that will be used to execute the Starting Sequence Sql |
Whether to forward failed messages and continue processing. This is the name of a linked component to forward the failed messages to. |
|
Sequence Attribute Name |
The name of the attribute in form [entity].[attribute] that should be filled in with the sequence number generated |
Select Starting Sequence Sql |
The Sql statement that will be executed in order to retrieve the starting sequence value. This sql will be run once on component start up to retrieve the sequence seed value |
Is Sequence Shared? |
Whether the sequence is shared among multiple sequence generators |
Shared Name |
If the sequence is shared, this is the name that each of the sequence generators will use to reference the shared sequence |
Reset on Attribute Change? |
Whether to reset the sequence counter when a new attribute is encountered |
Reset Attribute Name |
If the sequence is set to reset on Attribute Change, this is the name of the attribute to monitor |