SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-51
Manage Partitions of Range Partitioned Tables and
Indexes
add-move-boundary-range
is the boundary range.
[KEY=] FIRST KEY UPTO [KEY=] key-value
| [KEY=] key-value [THRU [KEY=] LAST KEY]
specifies the partitioning range add-move-boundary-range of a partition to
be split and then added to a new partition.
You can specify the partitioning range of a new partition to be added by
splitting off the beginning or end of an existing partition with the FIRST KEY
(start key value) up to, but not including, a key value key-value in the current
partition, or by a key value key-value in the current partition through the
LAST KEY (end key value). THRU [KEY=] LAST KEY is optional.
When you specify key-value, you can omit the values of the suffix columns
provided that the specified column values can adequately identify the partition.
If you omit column-value, MODIFY uses the default value, either the low or
high value of the corresponding partitioning key column, depending on whether
the column contains data in ascending or descending order.
[TO] LOCATION new-partition
specifies the location of the new partition.
new-partition
specifies a disk volume or a Guardian file for the new partition. If you use disk
volume syntax, MODIFY generates the file suffix name part. The specified new
partition can be on the local system or a remote system.
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition [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.