In this post, you’ll learn about the error message -509 the table identified in the update or delete statement is not the same table designated by the cursor in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-509 the table identified in the update or delete statement is not the same table designated by the cursor
Reason for the Error
The application program attempted to execute an UPDATE or� DELETE WHERE CURRENT OF cursor statement where the table named in that� statement did not match the name of the table specified in the declaration� for that cursor.
Solution
Correct the application program to ensure that the� table identified in the UPDATE or DELETE statement is the same table� identified in the declaration for the cursor.