HPE NonStop SQL/MX Error – 4200 Stream expressions are not supported for compound statements.

In this blog post, let’s learn about the error message “4200 Stream expressions are not supported for compound statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4200 Stream expressions are not supported for compound statements.

Reason for the Error

You attempted to use a stream expression for a compound statement.

Solution

Modify the statement and resubmit