Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 UDB COMMIT - RETURN SQLSTATE?

Status
Not open for further replies.

riffman

Programmer
Oct 16, 2003
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top