DB2 SQL-Error: -243
SQLState: 36001
Short Description: SENSITIVE CURSOR CANNOT BE DEFINED FOR THE SPECIFIED SELECT STATEMENT
The cursor cursor-name is defined as SENSITIVE, but the content of the SELECT statement makes the cursor read-only. In most cases the SELECT statement requires DB2 to build a temporary table or work file with the result table of the cursor, and DB2 cannot guarantee that changes made outside the cursor will be visible. In this case, the cursor must be defined INSENSITIVE or ASENSITIVE. System action: The statement cannot be processed. Programmer response: Either change the content of the query to result in a result table that is not read-only, or change the type of cursor to be INSENSITIVE or ASENSITIVE.