HPE NonStop SQL/MX Error – 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.

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

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, let’s learn about the error message “1104 Default value string is too long for column column-name.”...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “3165 The precision or exponent value specified in value was...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “2051 Either control optionoption name or value ‘value’is not valid.”...
  • Data
  • December 3, 2024