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


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

   
 
  • Causa
    • THE SET CONNECTION OR RELEASE STATEMENT MUST SPECIFY AN EXISTING CONNECTION.

      One of the following rules was violated:

      • A SET CONNECTION statement must identify an existing SQL connection of the application process.
      • A RELEASE statement must identify an existing connection of the application process.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • The correction depends on the error, as follows:
      • If the location name is not the intended name, correct it.
      • If the location name does not identify an existing SQL connection, replace the SET CONNECTION with a CONNECT statement.
      • If RELEASE CURRENT was executed in the unconnected state or the specified location name does not identify an existing SQL or DB2 private connection, delete the RELEASE statement.

      Correct the error in the application, rebind, the plan and resubmit the job.

      SQLSTATE: 08003
© Copyright IBM Corp.