HPE NonStop SQL/MX Error – 3180 STREAM statements are not allowed in compound statements.

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

Error Message

3180 STREAM statements are not allowed in compound statements.

Reason for the Error

You specified a compound statement that contains a STREAM statement, which is not supported.

Solution

Correct the syntax and resubmit