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-15

Syntax Description of ALTER SEQUENCE

sequence

specifies the ANSI name of a sequence generator.

sequence-generator-increment-by-option

alters the INCREMENT BY value to the user specified value. This value must be

less than the difference between the MAXVALUE and MINVALUE for the sequence

generator, and cannot be zero.

sequence-generator-maxvalue-option

alters the MAXVALUE to the user specified value. This value must satisfy the

following conditions:

It cannot be less than the CURRENT_VALUE and MINVALUE

It must be greater than the START WITH value

If NOMAXVALUE or NO MAXVALUE is specified, the MAXVALUE is set to the

maximum value of the sequence generator data type.

sequence-generator-minvalue-option

alters the MINVALUE to the user specified value. This value must satisfy the

following conditions:

It must be less than or equal to the CURRENT_VALUE and less than the

MAXVALUE

It must be less than or equal to the START WITH value

If NOMINVALUE or NO MINVALUE is specified, the MINVALUE is set to the

minimum value of the sequence generator data type.

sequence-generator-cycle-option

alters the CYCLE attriibute to the user specified value.

If user specified value is NO CYCLE, an exception is raised for the next value

after an ascending sequence reaches the maximum value or descending

sequence reaches the minimum value.

If user specified value is CYCLE, the sequence generator loops over to generate

the minimum value after an ascending sequence reaches the maximum value. The

sequence generator loops over to generate the maximum value after a descending

sequence reaches the minimum value.

sequence-generator-restart-with

resets the CURRENT_VALUE with the user specified value.