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


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 -501
   
 
  • Causa
    • THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN.

      The application program attempted to either:
      1. FETCH using a cursor, or
      2. CLOSE a cursor

      at a time when the specified cursor was not open.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Check for a previous SQL return code that may have closed the cursor.
      Commit and rollback operations close cursors.
      SQLCODES -404, -652, -679, -802, -901, -904, -909, -910, -911, and -913 will force the cursor to close.
      After the cursor is closed, any fetches or close cursor statements will receive this SQLCODE -501.

      If no previous SQL return codes have been issued, correct the logic of the application program to ensure that the cursor is open at the time the FETCH or CLOSE statement is executed.

      SQLSTATE: 24501

© Copyright IBM Corp.