logo  
Google
 

DB2 SQL-Error: -504

SQLState: 34000

Short Description: THE CURSOR NAME IS NOT DEFINED C C ROLLBACK C WITH HOLD COMMIT T COMMIT COMMIT COMMITONRETURN Y C S T P C T SQL I UNKNOWN T SQLDB C DECLARE CURSOR ALLOCATE CURSOR F COMMIT ROLLBACK CLOSE A COMMIT ROLLBACK CLOSE ASSOCIATE LOCATORS ALLOCATE CURSOR F COMMIT WITH HOLD COMMIT F ASSOCIATE LOCATORS ALLOCATE CURSOR

Cursor cursor-name was referenced in an SQL statement, and one of the following is true: v Cursor cursor-name was not declared (using the DECLARE CURSOR statement) or allocated (using the ALLOCATE CURSOR statement) in the application program before it was referenced. v Cursor cursor-name was referenced in a positioned UPDATE or DELETE statement which is not a supported operation for an allocated cursor. v Cursor cursor-name was allocated, but a CLOSE cursor statement naming cursor-name was issued and deallocated the cursor before this cursor reference.

 <-  BACK TO INDEX