Description
Returns the next sequential number. Similar to the SEQNUM function, but also provides a 1 based index so that multiple numbers from the sequence may be used on each source row.
Syntax
SEQNUMN ( initial_value, index )
| Parameter | Description |
|---|---|
| initial_value | The starting value for the sequence number. |
| index | The index number for this sequence. |
Remarks
This function can be called any number of times in any number of steps per row to get a complete sequence with no gaps. It can be ordered, for example, index 1 used for primary, index 2 used for secondary regardless of field, link or step order. SEQNUMN also allows indexes to be reused, for example index 1 used for primary header and detail, index 2 used for secondary header and detail.
See also