SQL - SQLCODE's - Códigos negativos -508


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 -508

   
 
  • Causa
    • O CURSOR identificado em uma declaração de UPDATE OU DELETE não está posicionado em uma linha.

      The application program attempted to execute an UPDATE or DELETE WHERE CURRENT OF cursor statement at a time when the specified cursor was not positioned on a row of the object table.
      The cursor must be positioned on the row that is to be updated or deleted.

      This SQL code can be issued if the cursor is no longer positioned on the row because another cursor in the same application program delete the row or updates an index column.
      This includes deletes and index column updates that are performed as a result of rolling back to a savepoint.
  • Ação do sistema
    • The statement cannot be executed.
      No data was updated or deleted.
  • Resposta ao Desenvolvedor
    • Correct the logic of the application program to ensure that the cursor is correctly positioned on the intended row of the object table before the UPDATE or DELETE statement is executed.
      Note that the cursor is not positioned on a row if FETCH returned an SQLCODE = 100.

      SQLSTATE: 24504

© Copyright IBM Corp.