HPE NonStop SQL/MX Error – 3186 string: Dynamic parameters and host variables are currently not allowed in DDL.

In this blog post, let’s learn about the error message “3186 string: Dynamic parameters and host variables are currently not allowed in DDL.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3186 string: Dynamic parameters and host variables are currently not allowed in DDL.

Reason for the Error

NonStop SQL/MX does not support the use of dynamic parameters or host variables in DDL statements.

Solution

Remove occurrences of dynamic parameters or host variables and resubmit