HPE NonStop SQL/MX Error – 20227 The specified syntax is not supported for a hash-partitioned table or index.

In this blog post, let’s learn about the error message “20227 The specified syntax is not supported for a hash-partitioned table or index.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20227 The specified syntax is not supported for a hash-partitioned table or index.

Reason for the Error

You issued a REUSE request for a hash-partitioned table, or you moved the hash partition to an existing partition location.

Solution

None. This is an internal error. Contact your service provider