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