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


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

   
 
  • Causa
    • A ROLLBACK OPERATION IS REQUIRED.

      The unit of work was placed in a state where a rollback operation is required.
      This can happen for the following reasons:

      • An SQL statement updated a distributed database server, but the database server can be used only for read-only operations.
        Either updates are currently restricted to servers that support distributed two-phase commit and this application server does not support distributed two-phase commit, or updates are restricted to a single server that does not support distributed two-phase commit and this application server is not that server.

        The unit of work must be terminated by a rollback operation because the update made (but not committed) at the application server cannot be committed consistently with other current or future updates made to this distributed unit of work.
      • An abend occurred during the execution of a stored procedure, or a restricted SQL statement was issued from a stored procedure.
      • An abend occurred during the execution of a function, or a restricted SQL statement was issued from a function.
  • 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
    • Correct the application, function, or stored procedure, rebind it, and resubmit the job.

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

      SQLSTATE: 56045
© Copyright IBM Corp.