logo  
Google
 

DB2 SQL-Error: -579

SQLState: 38004

Short Description: ATTEMPTED TO READ DATA WHEN THE DEFINITION OF THE FUNCTION OR PROCEDURE DID NOT SPECIFY THIS ACTION

The current environment does not allow SQL statements that read data. One of the following situations had occurred: v A user-defined function or stored procedure object-name was invoked and attempted to read data, but the function or procedure was defined without the READS SQL DATA or MODIFIES SQL DATA option. v A function or procedure defined with CONTAINS SQL or NO SQL has attempted to invoke another function or procedure defined with READS SQL DATA. In an environment of nested functions and procedures, the SQL option in effect is the most restrictive one that has been specified in the nested hierarchy of functions and procedures. The SQL data access option in effect does not allow for reading data. System action: The SQL statement failed. Programmer response: Either use an ALTER statement to change the definition of the function or procedure to allow statements that read data, or remove the failing SQL statement from the external function or procedure.

 <-  BACK TO INDEX