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


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

   
 
  • Causa
    • CURSOR cursor-name CANNOT BE USED BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT STATEMENT.

      The cursor 'cursor-name' could not be used as specified because the prepared statement named in the declaration for the cursor was not a SELECT statement.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Verify that the statement-name is specified correctly in the PREPARE statement and the DECLARE CURSOR statement for cursor 'cursor-name'.
      Alternatively, correct the application program logic to ensure that only prepared SELECT statements are used in association with cursor declarations.

      SQLSTATE: 07005

© Copyright IBM Corp.