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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-48
Reuse an Existing Partition of a Range Partitioned
Tabl e
LOCATION [\node.]$volume[.subvolume.file-name]
| [KEY=] {FIRST | LAST} PARTITION
| [KEY=] key-value
is a location for a partition, or the partitioning key (the FIRST KEY) value
(key-value) of a partition, to be modified.
If the partition is the primary partition, you can also specify the partition using the
FIRST PARTITION phrase. If the partition is the last partition in the list of partitions
of the table or index, you can use the LAST PARTITION phrase. You can use
either phrase to specify a partition if it is the only partition of the object.
[\node.]$volume
| [\node.]$volume.subvolume.file-name
is the physical location of a partition. If you do not specify the file name, a
volume can be used only once for a given table or index.
\node can be either the local node or a remote node. If you do not specify
\node, the default is the Guardian system named in your =_DEFAULTS define.
key-value
is the key value of a partition to be modified.
VALUE (column-value [,column-value]...)
is the boundary values for the partition to be modified. You can identify a
partition by its partitioning key value key-value. You can omit the values of
the suffix columns in the FIRST KEY value provided that the specified column
values can adequately identify the partition. If you omit a column-value,
MODIFY uses either the low value or the high value of the corresponding
partitioning key column, depending on whether the column stores data in
ascending or descending order.
WITH [KEY=] key-value
assigns the new partitioning key value key-value to the specified partition. If
you omit the values of the suffix columns, MODIFY uses the default value,
either the low or high value of the corresponding partitioning key column,
depending on whether the column contains data in ascending or descending
order. You can omit the column values only on the right of the list.
[[NO] PURGEDATA]
specifies whether the existing data in the specified partition is removed. If the
partition contains data and you do not explicitly specify the PURGEDATA option,
MODIFY returns an error. The default is NO PURGEDATA.