logo  
Google
 

DB2 SQL-Error: -740

SQLState: 51034

Short Description: FUNCTION 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: v VALUES clause of an INSERT statement v SET clause of an UPDATE statement v VALUES statement in a trigger v SET Assignment statement v CALL procedure statementSystem action: The SQL statement failed. Programmer response: Remove the user-defined function from the failing statement. or remove the MODIFIES SQL DATA option from the definition of the function.

 <-  BACK TO INDEX