SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—640322-001
5-118
Examples of PURGEDATA
•
Purgedata does not allow you to purge data from a referred table.
Examples of PURGEDATA
•
This example purges the data in the specified table. If the table has indexes, their
data is 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;