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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-77
Syntax Description of PURGEDATA
this list. PURGEDATA returns errors if the specified partitions do not exist, if
dependent indexes exist on the table, and if the source object does not exist.
partition-map
describes a partition or range of partitions:
guardian-name
specifies the partially or fully qualified Guardian name that identifies the
partition. If you specify only the volume, all partitions on the volume that
belong to the object are affected. If you do not specify \node, only the
local system is assumed. PURGEDATA returns an error if
guardian-name is not valid.
\node can refer to a remote system that must be visible to the current
(local) system.
first-key
identifies the partition by its first key value. Within the current object, every
partition is assigned a unique first key value. You can use this value later to
identify the partition. An error is returned if the first key value cannot be
found. first-key must match an existing key value for PURGEDATA
requests. Partition management operations can use different values for
boundary operations.
FIRST
specifies the first partition. For range-partitioned objects, the first
partition contains low or high values, depending on the ASC/DESC
attribute. For hash-partitioned objects, the first partition is zero (0).
LAST
specifies the last partition. For range-partitioned objects, the last
partition is the last value where its first key is greater than other first
keys. For hash-partitioned objects, the last partition is the maximum
number of partitions available minus one (1).
key-value
specifies the first key value used when the partition was created. You
can specify a range of partitions.
IGNORE_TRIGGER
specifies that PURGEDATA should ignore DELETE triggers on the table. If they are
not ignored and a DELETE trigger exists, PURGEDATA fails.