If SQL names were specified, the sequence will be created in the schema specified by the implicit or explicit qualifier.
If system names were specified, the sequence will be created in the schema that is specified by the qualifier. If not qualified:
For portability of applications across platforms, use DECIMAL instead of a NUMERIC data type.
This value is not necessarily the value that a sequence would cycle to after reaching the maximum or minimum value of the sequence. The START WITH clause can be used to start a sequence outside the range that is used for cycles. The range used for cycles is defined by MINVALUE and MAXVALUE.
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. The default is 1.
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 that can be specified is 2, and the maximum is the largest value that can be represented as an integer.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.