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-101
CREATE SEQUENCE Statement
sequence-generator-maxvalue-option
specifies the MAXVALUE for the sequence generator. The default is the maximum
value of the sequence generator data type.
If NO MAXVALUE or NOMAXVALUE is specified, MAXVALUE is the maximum
value of the sequence generator data type.
This value must be greater than MINVALUE and must be greater than or equal to
START WITH value.
sequence-generator-minvalue-option
specifies the MINVALUE for the sequence generator. The default is the minimum
value of the sequence generator data type.
If NO MINVALUE or NOMINVALUE is specified, MINVALUE is the minimum value
of the sequence generator data type.
This value must be less than MAXVALUE and must be less than or equal to
START WITH value.
sequence-generator-cycle-option
specifies the behavior of the sequence generator after reaching either the
maximum or minimum value. The default is NO CYCLE.
If NO CYCLE is specified, an exception is raised if a new value is requested from
the sequence generator after:
°
an ascending sequence reaches the maximum value
°
a descending sequence reaches the minimum value
If CYCLE is specified, the sequence generator loops over to:
°
generate the minimum value after an ascending sequence reaches the
maximum value
°
generate the maximum value after a descending sequence reaches the
minimum value
sequence-generator-cache-option
supported syntactically.
sequence-generator-order-option
supported syntactically.
sequence-file-option
specifies the location.