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


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

   
 
  • Causa
    • THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE A CONNECTION HAS BEEN LOST.

      Execution of the SQL statement failed because a communications link between the local DB2 and at least one remote server no longer exists.
      A previous failure caused this condition.
  • Ação do sistema
    • In the IMS and CICS environments, all SQL statements are rejected until the rollback occurs.
      In the other environments, all SQL statements other than a static ROLLBACK are rejected until a static ROLLBACK is executed.
  • Resposta ao Desenvolvedor
    • In general, an application program should issue a static ROLLBACK.
      Attempts by the application to issue SQL statements other than static ROLLBACK might fail.
      Once the static ROLLBACK is issued, the application can resume execution.

      SQLERRP contains the name of the module that detected the previous failure and placed the application in the must-abort state.

      SQLSTATE: 51021
© Copyright IBM Corp.