HPE NonStop SQL/MX Error – 20258 The WHERE clause cannot be used with table-name because it is a system-clustered base table.

In this blog post, let’s learn about the error message “20258 The WHERE clause cannot be used with table-name because it is a system-clustered base table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20258 The WHERE clause cannot be used with table-name because it is a system-clustered base table.

Reason for the Error

You specified the WHERE clause in the request to move the partition of a system-clustered base table to a new location.

Solution

None