In this blog post, let’s learn about the error message “20242 The table has DELETE triggers enabled on it. Please disable them and try again.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20242 The table has DELETE triggers enabled on it. Please disable them and try again.
Reason for the Error
The specified table has DELETE triggers enabled on it, so you cannot purge data from it.
Solution
Disable the DELETE trigger and retry the PURGEDATA request