When a stored procedure contains a commit statement, does DB2 complete the commit process and then return control and a sqlstate code to the stored procedure or does it start the commit process and return control immediately to the stored procedure with no return code.
Scenario
I have stored procedures that trigger other stored procedures and I suspect that even though the first stored procedure has completed, the data required for the second is not completely committed.
Thanks
Scenario
I have stored procedures that trigger other stored procedures and I suspect that even though the first stored procedure has completed, the data required for the second is not completely committed.
Thanks