HPE NonStop SQL/MX Error – 4202 SEQUENCE BY is not supported for embedded name expressions.

In this blog post, let’s learn about the error message “4202 SEQUENCE BY is not supported for embedded name expressions.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4202 SEQUENCE BY is not supported for embedded name expressions.

Reason for the Error

You attempted to perform an embedded expression that included SEQUENCE BY.

Solution

Modify the statement and resubmit