Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +222


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode +222

   
 
  • Causa
    • DELETE HOLE DETECTED USING cursor-name 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.

      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