DB2 SQL-Error: -746

Short Description: THE SQL STATEMENT IN AN EXTERNAL FUNCTION TRIGGER OR IN STORED PROCEDURE VIOLATES THE NESTING SQL RESTRICTION

If a table is being modified (by INSERT, DELETE or UPDATE), the table can not be accessed by the lower level nesting SQL statement. If any table is being accessed by a SELECT statement, no table can be modified (by INSERT, DELETE or UPDATE) in any lower level nesting SQL statement. System action: The SELECT, INSERT, DELETE or UPDATE SQL statement failed. Programmer response: Remove the failing statement from the named external function, trigger or the stored procedure.

 <-  BACK TO INDEX