HPE NonStop SQL/MX Error – 20252 Only a single ADD, MOVE, DROP, or REUSE request is allowed.

In this blog post, let’s learn about the error message “20252 Only a single ADD, MOVE, DROP, or REUSE request is allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20252 Only a single ADD, MOVE, DROP, or REUSE request is allowed.

Reason for the Error

You included more than one request to the MODIFY command. The REUSE request works only with range-partitioned tables.

Solution

None