-244 SENSITIVITY sensitivity SPECIFIED ON THE FETCH IS NOT VALID FOR CURSOR cursor-name
Explanation
The sensitivity option specified on FETCH conflicts with the sensitivity option in effect for cursor cursor-name. If a cursor is declared INSENSITIVE, the FETCH statement can only specify INSENSITIVE or nothing. If a cursor is declared SENSITIVE, the FETCH statement can specify INSENSITIVE, SENSITIVE, or nothing.
The
keyword INSENSITIVE is not allowed with the FETCH statements if the
associated cursor is either:
- Declared as SENSITIVE DYNAMIC SCROLL, or
- The cursor is declared ASENSITIVE, and DB2® selected the maximum allowable sensitivity of SENSITIVE DYNAMIC SCROLL for the associated SELECT statement.
- sensitivity
- Specified sensitivity for the FETCH statement.
- cursor-name
- Name of the cursor used for the FETCH statement.
System action
The statement cannot be processed.
Programmer response
Change or remove the sensitivity option that is specified on the FETCH.
SQLSTATE
428F4