-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.
In the case of a non-scrollable cursor, the sensitivity option cannot be specified.
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