HPE NonStop SQL/MX Error – 4170 Stream expressions are not supported for insert statements.

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

Error Message

4170 Stream expressions are not supported for insert statements.

Reason for the Error

You attempted to perform an insert statement that includes a stream expression.

Solution

Modify the statement and resubmit