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


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

   
 
  • Causa
    • A STORED PROCEDURE SPECIFYING COMMIT ON RETURN CANNOT BE THE TARGET OF A NESTED CALL STATEMENT.

      A stored procedure defined with the COMMIT ON RETURN attribute was called from a stored procedure, user-defined function, or trigger.
      Stored procedures defined with COMMIT ON RETURN cannot be nested in this way.
  • Ação do sistema
    • The SQL statement is not executed.
      If the CALL statement references a remote server, the unit of work is placed in a must rollback state.
  • Resposta ao Desenvolvedor
    • Remove the CALL to the stored procedure that was defined with the COMMIT ON RETURN attribute.

      SQLSTATE: 429B1
© Copyright IBM Corp.