Overview

Use the sequence To make it easy to create a sequence of unique numbers, PhixFlow has a Sequence item. In the repository, add a new sequence, and use its properties to set up a sequence of unique numbers that you want to allocate to records in a stream. 

To create a sequence, You need to specify a start value and a block size for the sequence. The block size specifies how often you go back to the database to update the number up to which you have allocated. This is referred to as the 'tidemark'. PhixFlow then allocates those numbers from the database and stores them in memory. When PhixFlow reserves a block, it marks the last reserved value in the database. 

...