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-277
Manage Partitions of Range Partitioned Tables and
Indexes
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
is a request to move an existing partition to a new location.
partition-identification is optional only if the table or index has only one
partition.
MOVE [PARTITION] WHERE
{partition-identification | add-move-boundary-range}
[TO] {PREVIOUS | NEXT} PARTITION
is a request to merge part or all of an existing partition to an adjacent existing
partition. You can specify an entire partition using the
partition-identification clause.
partition-identification
describes the partition.
LOCATION [\node.]$volume[.subvolume.file-name]
| NAME partition-name
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
is a location for a partition, or the partitioning key (the FIRST KEY) value
(key-value) of a partition, to be modified.
If the partition is the primary partition, you can also specify the partition using
the FIRST PARTITION phrase. If the partition is the rightmost partition in the
list of partitions of the table, you can use the LAST PARTITION phrase. You
can use either phrase to specify a partition if it is the only partition of the object.
[\node.]$volume
| [\node.]$volume.subvolume.file-name
is the physical location of a partition. If you do not specify the file name, only
one partition can exist for the given data source.
\node can be either the local node or a remote node. If you do not specify
\node, the default is the Guardian system named in your =_DEFAULTS define.
You can use the add-move-boundary-range clause to specify a range of
data in a partition (either the beginning part or the last part) to be split and then
merged into an adjacent and existing partition.
An operation is a prefix merge if the range of dat
a begins from the top of the
existing partition. For a prefix merge operation, you can specify only the TO
PREVIOUS PARTITION clause. The split partition cannot be the primary
partition.