Each of the existing START WITH, INCREMENT BY, MINVALUE, and MAXVALUE attributes that are not changed by the ALTER SEQUENCE statement must contain a value that could be assigned to a column of the data type associated with the new data type.
For portability of applications across platforms, use DECIMAL instead of a NUMERIC data type.
If the value is zero or positive, the sequence of values for the sequence ascends. If the value is negative, the sequence of values descends.
When CYCLE is in effect, duplicate values can be generated for a sequence by the database manager.
In certain situations, such as system failure, all cached sequence values that have not been used in committed statements are lost, and thus, will never be used. The value specified for the CACHE option is the maximum number of sequence values that could be lost in these situations.
The minimum value is 2.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.