In this blog post, let’s learn about the error message “20225 Table table-name is a hash-partitioned object. PURGEDATA does not allow individual or sets of partitions to be purged, only the entire table can be purged.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20225 Table table-name is a hash-partitioned object. PURGEDATA does not allow individual or sets of partitions to be purged, only the entire table can be purged.
Reason for the Error
You attempted to purge individual partitions of a hash-partitioned table, which is not supported.
Solution
Either purge the entire file or use a DELETE statement (DML statement) to remove the required rows
