DB2 SQL-Error: -244

Short Description: SENSITIVITY SPECIFIED ON THE FETCH IS NOT VALID FOR CURSOR C N FETCH S T P C FETCH

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: v Declared as SENSITIVE DYNAMIC SCROLL, or v 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.

 <-  BACK TO INDEX