In this blog post, let’s learn about the error message “11046 Host variables and dynamic parameters are not allowed in the action of a trigger.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11046 Host variables and dynamic parameters are not allowed in the action of a trigger.
Reason for the Error
You attempted to create a trigger that includes host variables or dynamic parameters in its action. This can happen when you specify CALL statements or compound actions as triggered actions.
Solution
Rewrite the trigger so that host variables and dynamic parameters do not appear in the trigger action. Then retry the operation
