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-287
Managing a Sequence Generator
primary extent and that of secondary extents separately. If you do not specify
EXTENT, MODIFY uses the extent size values of the largest partition.
See EXTENT on page 9-6 and MAXEXTENTS on page 9-7.
Managing a Sequence Generator
You can use MODIFY to move the existing partition of a sequence generator to a new
location. A sequence generator can have only a single partition. Only offline partition
operations are supported.
[[catalog.]schema.]sequence
specifies the ANSI name of the sequence generator. If you do not specify the
schema and the catalog name, SQL/MX uses the current catalog and schema.
[\node.]$volume[.sub-volume.file-name]
specifies the disk volume or a Guardian file for the new location of the sequence
generator. If you use the disk volume syntax, MODIFY generates a file name. The
node can either be the local or a remote node. If you do not specify a node, the
default is the Guardian system named in your =_DEFAULTS define.
The MODIFY form for sequence generator is:
MODIFY SEQUENCE [[catalog.]schema.]sequence
MOVE [ PARTITION ] [ TO ] new-location
new-location is:
LOCATION [\node.]$volume[.sub-volume.file-name]