SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-46
Manage Partitions of Range Partitioned Tables and
Indexes
[[catalog.]schema.]object
is the name of the range partitioned object. If you do not specify the schema and
catalog name, NonStop SQL/MX uses the default catalog and schema of your
MXCI session. object is a table or an index, depending on the TABLE or INDEX
keyword.
DROP [PARTITION] WHERE partition-identification
is a request to drop a range partition. The specified partition must be empty.
partition-identification
describes the partition.
LOCATION [\node.]$volume[.subvolume.file-name]
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
is a location, or a partition, or the partitioning key (the FIRST KEY) value
key-value of a partition to be moved or dropped.
When you drop a partition, its key range is merged into the previous partition
unless the first partition is dropped. If you drop the first partition, its key range is
merged into the next partition.
[\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.
ADD [PARTITION] WHERE add-move-boundary-range
[TO] LOCATION new-partition [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.
commit-options is:
{ COMMIT WORK [ WHEN READY ] }
{ [ { AFTER time } ] }
{ [ { BEFORE time } ] }