Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -224

THE RESULT TABLE DOES NOT AGREE WITH THE BASE TABLE USING cursor-name

Conclusão: DB2 attempted a positioned UPDATE or DELETE was attempted on a row that no longer matches its previous condition. The column values in the result table row do not match the current values in the base table row because the row was updated between the time it was inserted into the result table and the positioned update or delete was executed.

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 same row.

Resposta ao 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: 24512


© Copyright IBM Corp.