Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
C. A. Dornelles
SQL - SQLCODE's - Códigos positivos
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +222
DELETE HOLE DETECTED USING
cursor-name
Causa:
DB2 could not FETCH data for cursor
cursor-name
because the corresponding row of the underlying table was deleted, resulting in a
delete
hole
. DB2 detected the
delete
hole
when it processed a FETCH for cursor
cursor-name
.
Nome do cursor:
Name of the cursor used for the FETCH statement.
Ação do sistema:
The statement cannot be processed. The cursor is repositioned on the hole.
Resposta ao Desenvolvedor:
Correct the application program to handle this situation or change isolation levels so the base row cannot be deleted during the cursor operation.
SQLSTATE: 02502
