In this blog post, let’s learn about the error message “21072 target-table has a SYSKEY column and is the subject table for a trigger.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21072 target-table has a SYSKEY column and is the subject table for a trigger.
Reason for the Error
The target table for an initial FASTCOPY command has a system defined SYSKEY column, and is the subject table for one or more triggers. A FASTCOPY command cannot operate on such a table.
Solution
Drop all triggers that have the target table as subject table, retry the FASTCOPY command, and then recreate the triggers. If necessary, execute queries that will perform the trigger actions