SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—544536-007
10-46
Examples of Using PURGEDATA to Delete Table
Data
•
Another table references the named table through a trigger or referential integrity
constraint.
•
You attempt to perform PURGEDATA within a user-defined transaction. There is no
notion of a transaction existing for a table.
Examples of Using PURGEDATA to Delete Table Data
This example purges the data in the specified table. If the table has indexes, the
indexes are also purged.
PURGEDATA mycat.myschema.mytable;
This example purges the data in the specified partition, which has a Guardian name:
PURGEDATA mycat.myschema.mytable
WHERE LOCATION $DATA1.ZSDA09TO.QZ780000;
This example purges data from all partitions of the table:
PURGEDATA mycat.myschema.mytable
WHERE KEY = FIRST PARTITION THRU LAST PARTITION;