In this blog post, let’s learn about the error message “4168 Stream expressions 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
4168 Stream expressions are not supported in subqueries.
Reason for the Error
You attempted to perform a subquery that included a stream expression.
Solution
Modify the statement and resubmit