logo  
Google
 

DB2 SQL-Error: -228

SQLState: 42620

Short Description: FOR UPDATE CLAUSE SPECIFIED FOR READONLY CURSOR

A cursor was declared read-only with the INSENSITIVE SROLL option, but the SELECT statement contained a FOR UPDATE clause. cursor-name Name of the cursor used for the FETCH.System action: The statement cannot be processed. Programmer response: To define a scrollable cursor that is read-only, specify INSENSITIVE SCROLL, but do not specify FOR UPDATE clause. To define a scrollable cursor that can be updated, specify SENSITIVE SCROLL. Corect the application program to DECLARE CURSOR appropriately.

 <-  BACK TO INDEX