-228   FOR UPDATE CLAUSE SPECIFIED FOR READ-ONLY CURSOR cursor-name

Explanation

A cursor was declared read-only with the INSENSITIVE SCROLL 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. Correct the application program to DECLARE CURSOR appropriately.

SQLSTATE

42620