Sequence Editor option

Name — Enter a valid identifier as a name for your sequence. The name can be up to 32 characters long.

Multi-tenant — For databases enabled for multi-tenancy, yes if the sequence is multi-tenant.

Initial Value — Enter an initial integer value for the sequence, or accept the default of 0. The initial value becomes the lower limit if the Increment By value is positive and becomes the upper limit if the Increment By value is negative. You cannot specify an initial value that is greater than your upper limit or less than your lower limit, if defined.

Increment By — Enter a positive or negative integer value by which you want to change the sequence value at each increment, or accept the default of 1. If you enter a positive value, then each increment increases the sequence toward a defined upper limit. If you enter a negative value, then each increment decreases the sequence toward a defined lower limit, and the Upper Limit label changes to Lower Limit.

Upper Limit or Lower Limit — Enter an INT64 (if 64-bit sequences are enabled) or integervalue to define the upper or lower limit of the sequence, or accept the default value of unknown (?). If you specify a positive value for the Increment By field, you can only define an upper limit. If you specify a negative value, you can only specify a lower limit. You cannot specify an upper limit that is less than the initial value. Likewise, you cannot specify a lower limit that is greater than the initial value. If you accept the default, the Sequence Editor uses the maximum integer value on your system as the defined upper limit and the minimum integer value as the defined lower limit.

Cycle at limit — Indicates whether the sequence becomes a cycling or terminating sequence. A cycling sequence restarts at the initial value when it reaches the upper limit or decrements beyond its lower limit, providing non-unique values for the life of the sequence. A terminating sequence stops incrementing when it reaches the upper limit or stops decrementing when it reaches its lower limit, providing unique values as long as you do not explicitly reset it. The default is no, indicating a terminating sequence.

DataServer Name — For non-OpenEdge databases only. Displays the name of the corresponding non-OpenEdge sequence, if there is one.

Owner — For non-OpenEdge databases only. Displays the name of the user who has permission to access the sequence.