SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-16
Considerations for ALTER SEQUENCE
numeric-literal
an exact numeric literal corresponding to the sequence generator data type. It
cannot be greater than the maximum value or less than the minimum value of the
sequence generator data type.
rename-clause
alters the logical name of a sequence generator.
new-sequence-name
specifies the new ANSI name for the sequence generator. The new ANSI name
cannot be qualified. The renamed sequence generator remains in the current
catalog and schema.
Considerations for ALTER SEQUENCE
You cannot use the ALTER SEQUENCE statement to change the partition name. For
more information, see Managing a Sequence Generator on page 2-287.
Authorization Requirements
The schema owner, the Super ID or the object owner can execute the ALTER
SEQUENCE statement.
Restrictions
°
You cannot alter START WITH, CACHE and ORDER attributes for a sequence
generator.
°
You cannot specify the INCREMENT BY, MAXVALUE or NOMAXVALUE or NO
MAXVALUE, MINVALUE or NOMINVALUE or NO MINVALUE attributes more
than once in the statement.
°
You cannot use the RESTART WITH and RENAME options with other
attributes in the statement.
Examples of ALTER SEQUENCE
•
This example changes the MAXVALUE of MYSEQ sequence generator:
ALTER SEQUENCE MYSEQ MAXVALUE 1000;
•
This example changes the INCREMENT BY value of MYSEQ sequence generator:
ALTER SEQUENCE MYSEQ INCREMENT BY 10;
•
This example changes the sequence generator option to CYCLE:
ALTER SEQUENCE MYSEQ CYCLE;