-501 Referenced cursor is not open - Preprocessor2 for Embedded SQL

-501 Referenced cursor is not open

Possible Cause

The cursor referenced has been declared, but is not open.

Possible Solution

Open the cursor prior to cursor processing. If not explicitly closed (i.e., CLOSE request, COMMIT request, or an explicit ABORT/ROLLBACK request), verify that an implicit rollback did not occur. (An implicit rollback closes all open cursors associated with the current transaction.)