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