In this blog post, let’s learn about the error message “20039 For the MOVE, DROP, and REUSE requests, the key range must specify an exact partition range.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20039 For the MOVE, DROP, and REUSE requests, the key range must specify an exact partition range.
Reason for the Error
You used the add-move-boundary-range syntax instead of partition-identification to identify a partition to be moved, dropped, or reused, but you did not specify the exact partition range.
Solution
Reissue the request with the correct partition range. Consider using the partition-identification syntax instead
