SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-88
Manage Partitions of Hash Partitioned Tables and
Indexes
[[catalog.]schema.]object
is the name of the object. If you do not specify the schema and catalog name,
MODIFY uses the current default schema and catalog of your MXCI session.
object is a table or an index, depending on the TABLE or INDEX keyword.
DROP [PARTITION] WHERE partition-identification
drops a hash partition. The specified partition must be the last partition (the
rightmost partition in the partition array).
partition-identification
describes the partition.
LOCATION [\node.]$volume[.subvolume.file-name]
| NAME partition-name
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] VALUE(partition-number)
is the location for a partition, or the partitioning key (the FIRST KEY) value
(key-value) of a partition, to be dropped.
If you use the LOCATION clause, you must identify the last partition of the
table or index.
If you use partition-number, it must an unsigned integer and range
from 0 to n-1, where n is the number of partitions. VALUE(0) represents the
first partition, VALUE(1) represents the partition adjacent to the first
partition, and so on. VALUE(n-1) represents the last partition.
When you drop a hash partition, data from that partition is redistributed to
the remaining partitions.
new-partition is:
LOCATION [\node.]$volume[.subvolume.file-name]
<with-shared-access> is:
WITH SHARED ACCESS [commit-options]
commit-options is:
{ COMMIT [WORK] [ WHEN READY ] [on-error] }
{ [ { AFTER time } ] }
{ [ { BEFORE time } ] }
{ ROLLBACK [WORK] }
on-error is:
[ ONCOMMITERROR commit-options ]