In this blog post, let’s learn about the error message “11017 The left hand side of a SET assignment must be qualified with the name of the NEW transition variable.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11017 The left hand side of a SET assignment must be qualified with the name of the NEW transition variable.
Reason for the Error
You specified a SET operation as an action for your BEFORE trigger, but the SET assignment is to an identifier.
Solution
Prefix the assignment to the SET operation with the NEW transition variable name and resubmit
