In this blog post, let’s learn about the error message “11024 Specifying the same name, var-name, for both OLD and NEW is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11024 Specifying the same name, var-name, for both OLD and NEW is not allowed.
Reason for the Error
You attempted to create a trigger with a clause using the same name for both the NEW and OLD transition variables.
Solution
Specify different names for the OLD and NEW transition variables and resubmit
