AN UPDATE OR DELETE OPERATION WAS ATTEMPTED AGAINST A HOLE USING cursor-name

Conclusão: DB2 could not process a positioned update or delete with cursor cursor-name that is defined as SENSITIVE STATIC. The selected row is either a delete hole or an update hole. DB2 detects these holes when DB2 tries to delete or update the current row of the result table for cursor cursor-name, and cannot locate the corresponding row of the underlying table.

A delete hole occurs when the corresponding row of the underlying table has been deleted.

An update hole occurs when the corresponding row of the underlying table has been updated, and the updated row no longer satisfies the search condition that is specified in the SELECT statement of the cursor.

Ação do sistema: The statement cannot be processed. The cursor is positioned on the hole.

Resposta ao Desenvolvedor: Issue a FETCH statement to position the cursor on a row.

SQLSTATE: 24510