|
AN UPDATE OR DELETE OPERATION WAS ATTEMPTED AGAINST AN UPDATE HOLE >USING cursor-name
Conclusão: DB2 detected an update hole when DB2 attempted a positioned
UPDATE or DELETE on a row that no longer satisfies its previous search
condition. An update hole is created when a row exists in the result table
and the resulting row has been updated in the base table such that the row
no longer satisfies the search condition in the SELECT statement.
cursor-name Name of the cursor used for the positioned update or delete.
Ação do sistema: The statement cannot be processed. The cursor is
positioned on the table.
Resposta do Desenvolvedor: Correct the application program to handle this error
condition or change isolation levels so the base row cannot be updated
during the cursor operation.
SQLSTATE: 24511
© Copyright IBM Corp.
|
