XML Guide

10.4.0
- 10.5

Back Next

Setting Sequence Numbers for Generated Keys

Each view in the XML Source Qualifier definition has a primary key and sequence value for the key. During a session, the Integration Service generates keys from sequence values and increments the values.

At the end of the session, the Integration Service updates each sequence value in the repository to the current value plus 1. These values become the start values the next time the Integration Service processes the Sequence Generator transformation.

The repository maintains the following sequence values:

Default value
. The sequence value for a key that appears in the XML Source Qualifier when you first create the source qualifier. The default is 1 for each key.

Start value.
A sequence number value for a key at the start of a session. You can view the start values in the XML Source Qualifier transformation before you run a workflow.

Current value.
A sequence value for a key during a session.

The start values for the generated keys display in the Sequence column in the XML Source Qualifier.

If you edit the sequence start values on the Ports tab, you must save the changes and exit the Designer before you run a workflow.

Rename Saved Search

Table of Contents

XML Guide

XML Guide

Setting Sequence Numbers for Generated Keys

Setting Sequence Numbers for Generated Keys