In this post, you’ll learn about the error message -507 the cursor identified in the update or delete statement is not open in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-507 the cursor identified in the update or delete statement is not open
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 open.
Solution
Check for a previous SQLCODE that may have closed� the cursor.� SQL codes -404, -652, -679, -901, -904, -909, -910, -911, and� -913 will force the cursor to close.� After the cursor is closed, any� fetches or close cursor statements will receive SQLCODE -501.� Any updates� or deletes will receive this SQLCODE -507.� Correct the logic of the� application program to ensure that the specified cursor is in fact open at� the time the UPDATE or DELETE statement is executed.
