In this blog post, let’s learn about the error message “20122 Table has indexes. Cannot purge data from partition.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20122 Table has indexes. Cannot purge data from partition.
Reason for the Error
You attempted to perform a partial PURGEDATA operation, which is supported only on tables that do not have dependent indexes. The table you requested has dependent indexes.
Solution
Remove any associated indexes and resubmit. If this is not possible, perform a DELETE request in the range of the specified partition
