SENSITIVE CURSOR cursor-name CANNOT BE DEFINED FOR THE SPECIFIED SELECT STATEMENT

Conclusão: The cursor cursor-name is defined as SENSITIVE, but the content of of the SELECT statement requires DB2 to build a temporary table with the result table of the cursor, and DB2 cannot guarantee that changes made outside the cursor will be visible. This could result from the content of the query making the result table read-only. In this case the cursor must be defined INSENSITIVE.

Ação do sistema: The statement cannot be processed.

Resposta do Desenvolvedor: Either change the content of the query to not be read-only, or change the type of cursor to be INSENSITIVE.

SQLSTATE: 36001