logo  
Google
 

DB2 SQL-Error: -729

SQLState: 429B1

Short Description: 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. System action: 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. Programmer response: Remove the CALL to the stored procedure that was defined with the COMMIT ON RETURN attribute.

 <-  BACK TO INDEX