HPE NonStop SQL/MX Error – 4171 Embedded name statements are not supported in INSERT statements.

In this blog post, let’s learn about the error message “4171 Embedded name statements are not supported in INSERT statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4171 Embedded name statements are not supported in INSERT statements.

Reason for the Error

You attempted to perform an INSERT that included an embedded statement.

Solution

Modify the statement and resubmit