HPE NonStop SQL/MX Error – 30020 Embedded update/delete cannot be used with SELECT…INTO and rowset.

In this blog post, let’s learn about the error message “30020 Embedded update/delete cannot be used with SELECT…INTO and rowset.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

30020 Embedded update/delete cannot be used with SELECT…INTO and rowset.

Reason for the Error

You attempted to use an embedded UPDATE or DELETE with SELECT…INTO and rowset.

Solution

Correct the syntax and resubmit