logo  
Google
 

DB2 SQL-Error: -517

SQLState: 07005

Short Description: CURSOR CANNOT BE USED BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT STATEMENT

The cursor 'cursor-name' could not be used as specified because the prepared statement named in the declaration for the cursor was not a SELECT statement. System action: The statement cannot be executed. Programmer response: Verify that the statement-name is specified correctly in the PREPARE statement and the DECLARE CURSOR statement for cursor 'cursor-name'. Alternatively, correct the application program logic to ensure that only prepared SELECT statements are used in association with cursor declarations.

 <-  BACK TO INDEX