In this blog post, let’s learn about the error message “30021 Rowsets cannot be used in the SET clause if there are no corresponding rowsets in the WHERE clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
30021 Rowsets cannot be used in the SET clause if there are no corresponding rowsets in the WHERE clause.
Reason for the Error
You attempted to use a rowset in the SET clause of an UPDATE statement when a corresponding rowset is not present in the WHERE clause.
Solution
Correct the syntax and resubmit