In this post, you’ll learn about the error message +100 row not found for fetch, update or delete, or the result of a query is an empty table in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
+100 row not found for fetch, update or delete, or the result of a query is an empty table
Reason for the Error
One of the following conditions occurred: *�� No row met the search conditions specified in an UPDATE or DELETE statement. *�� The result of a SELECT INTO statement was an empty table. *�� A FETCH statement was executed when the cursor was positioned after the last row of the result table. *�� The result of the subselect of an INSERT statement is empty. When a SELECT statement is executed using SPUFI, this SQL code indicates normal completion.
Solution
If expecting data, verify WHERE clause for accuracy and completeness.
