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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-47
MODIFY Utility
MODIFY Utility
Considerations for MODIFY
Examples of MODIFY
MODIFY is a syntax-based utility that can be executed through MXCI that enables
database administrators to perform partition operations on range and hash partitions of
SQL/MX tables and indexes. Depending on the type of operation you are performing,
MODIFY can be run as an online or offline operation. See Considerations for MODIFY
on page 5-58 for details about limitations on online operations.
The four forms of the MODIFY statement are:
•
Reuse an Existing Partition of a Range Partitioned Table
•
Manage Partitions of Range Partitioned Tables and Indexes
•
Manage Partitions of Hash Partitioned Tables and Indexes
•
Manage System-Clustered Tables
Reuse an Existing Partition of a Range Partitioned Table
Use MODIFY to reuse an existing range partition of a table by setting the FIRST KEY
values of the partition to new values. You can optionally remove existing data in the
partition to be reused. No data can exist in the new key range. Only offline operations
are supported.
[[catalog.]schema.]table
specifies the name of the table. If you do not specify the schema and catalog name
parts, MODIFY uses the current default catalog and schema of your MXCI session.
partition-identification
describes the partition.
The REUSE form of MODIFY is:
MODIFY TABLE [[catalog.]schema.]table
REUSE [PARTITION] WHERE partition-identification
WITH [KEY=] key-value
[[NO] PURGEDATA]
partition-identification is:
LOCATION [\node.]$volume[.subvolume.file-name]
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
key-value is:
VALUE (column-value [,column-value]...)