HPE NonStop SQL/MX Error – 11024 Specifying the same name, var-name, for both OLD and NEW is not allowed.

Data 35 Views 1 Min Read

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

Tags: