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


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 -740
   
 
  • Causa
    • FUNCTION name IS DEFINED WITH THE OPTION MODIFIES SQL DATA WHICH IS NOT VALID IN THE CONTEXT IN WHICH IT WAS INVOKED

      A user-defined function defined with MODIFIES SQL DATA is only allowed in:

      • VALUES clause of an INSERT statement
      • SET clause of an UPDATE statement
      • VALUES statement in a trigger
      • SET Assignment statement
      • CALL procedure statement
  • Ação do sistema
    • The SQL statement failed.
  • Resposta ao Desenvolvedor
    • Remove the user-defined function from the failing statement or remove the MODIFIES SQL DATA option from the definition of the function.

      SQLSTATE: 51034
© Copyright IBM Corp.