HPE NonStop SQL/MX Error – 4167 Embedded name statements are not supported in subqueries.

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

Error Message

4167 Embedded name statements are not supported in subqueries.

Reason for the Error

You attempted to perform a subquery that included an embedded statement.

Solution

Modify the statement and resubmit