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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-49
Manage Partitions of Range Partitioned Tables and
Indexes
Manage Partitions of Range Partitioned Tables and Indexes
Use MODIFY to manage range partitions of SQL/MX tables and indexes. You must
manage tables and indexes separately regardless of their relationship. Both offline and
online operations are supported. See Considerations for MODIFY on page 5-58 for
details about limitations on online operations.
The form of MODIFY for range partitioned tables and indexes is:
MODIFY { TABLE | INDEX } [[catalog.]schema.] object
{ drop | add | move }
drop is:
DROP [PARTITION] WHERE partition-identification
add is:
ADD [PARTITION] WHERE add-move-boundary-range
[TO] LOCATION new-partition [partition-size]
[with-shared-access]
move is one of:
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition [partition-size]
[with-shared-access]
MOVE [PARTITION]
WHERE {add-move-boundary-range | partition-identification}
[TO] {PREVIOUS | NEXT} PARTITION
[with-shared-access]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
add-move-boundary-range is:
[KEY=] FIRST KEY UPTO [KEY=] key-value
| [KEY=] key-value [THRU [KEY=] LAST KEY]
key-value is:
VALUE (column-value [,column-value]...)
partition-size is:
partition-extent-size [ MAXEXTENTS num-extents ]
partition-extent-size is:
EXTENT { pri-ext-size }
{ (pri-ext-size, sec-ext-size) }
with-shared-access is:
WITH SHARED ACCESS [commit-options]