DB2 Error Code – -502 the cursor identified in an open statement is already open

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.

Solution

Correct logic in application program to CLOSE the CURSOR before the OPEN statement.