HPE NonStop SQL/MX Error – 3426 Dynamic parameters and host variables are not allowed in the WHERE clause of multi commit statements.

Data 23 Views 1 Min Read

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

Tags: