In this blog post, let’s learn about the error message “3426 Dynamic parameters and host variables are not allowed in the WHERE clause of multi commit statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3426 Dynamic parameters and host variables are not allowed in the WHERE clause of multi commit statements.
Reason for the Error
You used a host variable in the WHERE clause of a multi commit statement.
Solution
Do not use a host variable or a dynamic parameter in the WHERE clause of a multi commit statement
