In this post, you’ll learn about the error message -508 the cursor identified in the update or delete statement is not positioned on a row in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-508 the cursor identified in the update or delete statement is not positioned on a row
Reason for the Error
The application program attempted to execute an UPDATE or� DELETE WHERE CURRENT OF cursor statement at a time when the specified� cursor was not positioned on a row of the object table.� The cursor must� be positioned on the row that is to be updated or deleted.� Note that the cursor is no longer positioned on a row if the row is� deleted or an index column of the row is updated by another cursor in the� same application program.
Solution
Correct the logic of the application program to� ensure that the cursor is correctly positioned on the intended row of the� object table before the UPDATE or DELETE statement is executed.� Note that� the cursor is not positioned on a row if FETCH returned an SQLCODE = 100.
