DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501

SQL0514N  The cursor \"\" is not in a prepared state.

Explanation:

The application program tried to use a cursor that is not in a prepared

state. The cursor is associated with a statement that meets the

following conditions:

1. was never prepared

2. was made not valid by either an explicit or implicit rebind of the

   package

3. was prepared in a previous transaction and the application\'s package

   is bound with KEEPDYNAMIC NO

The statement cannot be processed.

User response:

1. Prepare the statement named in the DECLARE CURSOR statement before  you try to open the cursor.

2. The prepare for the cursor must be reissued.

3. The statement should be prepared again after COMMIT or ROLLBACK.

   Alternatively, either bind the package with KEEPDYNAMIC YES or use

   the ALTER PACKAGE statement to change the KEEPDYNAMIC property to   YES.