In this blog post, let’s learn about the error message “30037 The search-condition for a DELETE [FIRST N] statement contains a rowset.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
30037 The search-condition for a DELETE [FIRST N] statement contains a rowset.
Reason for the Error
The search-condition for a DELETE [FIRST N] statement contains a rowset.
Solution
Remove the rowset host variable or parameter from the search-condition