Notes
Altering a sequence:
- Only future sequence numbers are affected by the ALTER SEQUENCE statement.
- All the cached values are lost when a sequence is altered.
- After restarting a sequence or changing it to cycle, it is possible that
a generated value will duplicate a value previously generated for that sequence.
Syntax alternatives: The following keywords are synonyms
supported for compatibility to prior releases of other DB2(R) UDB products.
These keywords are non-standard and should not be used:
- The keywords NOMINVALUE, NOMAXVALUE, NOCYCLE, NOCACHE, and NOORDER can
be used as synonyms for NO MINVALUE, NO MAXVALUE, NO CYCLE, NO CACHE, and
NO ORDER.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.