In this post, you’ll learn about the error message -502 the cursor identified in an open statement is already open in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-502 the cursor identified in an open statement is already open
Reason for the Error
The application program attempted to execute an OPEN� statement for a cursor that was already open.
Correct logic in application program to CLOSE the CURSOR before the OPEN statement.