DB2 SQL-Error: -514
SQLState: 26501
Short Description: THE CURSOR IS NOT IN A PREPARED STATE
The application program has tried to use a cursor, 'cursor-name,' that is not in a prepared state. The cursor is associated with a statement that either (1) has never been prepared, or (2) has been invalidated by a commit or rollback operation. System action: The statement cannot be executed. Programmer response: For case (1), ensure that you prepare the statement that is named in the DECLARE CURSOR statement for 'cursor-name' before you try to open the cursor. For case (2), do one of the following: v Use the WITH HOLD option of DECLARE CURSOR. v Do not execute a commit or rollback operation until you are finished using the cursor. v Prepare the statement again after the commit or rollback.