In this blog post, let’s learn about the error message “11012 An INSERT trigger cannot reference OLD values.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11012 An INSERT trigger cannot reference OLD values.
Reason for the Error
You attempted to create an INSERT trigger specifying an OLD transition variable.
Solution
You cannot use the OLD transition variable with an INSERT trigger because there is no old image for a row to be inserted
