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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-44
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, 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, only
one partition can exist for the given data source.
\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 a 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 column-value, 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.