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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-45
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. For information about limitations on online operations,
see Considerations for MODIFY on page 5-54.
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 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]