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


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 -925
   
 
  • Causa
    • COMMIT NOT VALID IN IMS, CICS OR RRSAF ENVIRONMENT.

      An application executing in either an IMS or CICS environment or an application executing in an RRSAF environment when DB2 is not the only resource manager has attempted to execute a COMMIT statement.
      The SQL COMMIT statement cannot be executed in these environments.
  • Ação do sistema
    • The statement cannot be executed. No commit is performed.
  • Resposta ao Desenvolvedor
    • The IMS, CICS or RRS protocols should be used to commit work in these environments.

      If a stored procedure is being called from IMS or CICS, ensure that the stored procedure is not defined to perform a commit on return.

      SQLSTATE: 2D521
© Copyright IBM Corp.