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-276
Manage Partitions of Range Partitioned Tables and
Indexes
ADD [PARTITION] WHERE add-move-boundary-range
[TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
specifies a request to split a range of data in an existing partition (either the
beginning part or the last part) and then move it to a new partition. Data can exist
in the range being added.
An operation is a prefix split if the range of data begins from the top of the existing
partition. An operation is a postfix split if the range ends at the bottom of the
partition.
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.
new-partition-name
is a SQL identifier for a partition.