HPE NonStop SQL/MX Error – 4173 Stream expression is not supported for top level UPDATE statements.

In this blog post, let’s learn about the error message “4173 Stream expression is not supported for top level UPDATE statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4173 Stream expression is not supported for top level UPDATE statements.

Reason for the Error

You attempted to perform a top-level UPDATE statement that included a stream expression.

Solution

Modify the statement and resubmit