SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-71
Manage Partitions of Range Partitioned Tables and
Indexes
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
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
move is one of:
MOVE [PARTITION] [WHERE partition-identification]
[TO] LOCATION new-partition
[NAME new-partition-name]
[partition-size]
[RECLAIM | NO RECLAIM]
[with-shared-access]
MOVE [PARTITION]
WHERE {add-move-boundary-range | partition-identification}
[TO] {PREVIOUS | NEXT} PARTITION
[RECLAIM | NO RECLAIM]
[with-shared-access]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| NAME partition-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]