Sequences are database objects that provide incremental values to an application. They can generate sequential values within any range of an ABL integer (–2,147,483,648 to 2,147,483,647) and with your choice of increment (positive or negative).
You can also define sequences to cycle or terminate when a specified limit is reached. A cycling sequence restarts after it reaches the specified limit, providing non-unique values for the life of the sequence. A terminating sequence stops incrementing after it reaches the specified limit, providing unique values for the life of the sequence as long as you do not explicitly reset it.
