In this blog post, let’s learn about the error message “20145 Key range specified for a table that is not a key-sequenced table. PURGEDATA cannot be performed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20145 Key range specified for a table that is not a key-sequenced table. PURGEDATA cannot be performed.
Reason for the Error
You attempted to perform a PURGEDATA operation on a table by specifying a key range. The table is not a key-sequenced table and therefore there are no key ranges to specify.
Solution
Perform the PURGEDATA request without specifying key ranges
