In this blog post, let’s learn about the error message “21071 target-table has DELETE triggers enabled.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21071 target-table has DELETE triggers enabled.
Reason for the Error
The target table for an initial FASTCOPY command is non-empty; is the subject table for a DELETE trigger that is enabled.
Solution
Disable DELETE triggers on the target table, retry the FASTCOPY command, and then enable the triggers again
