I have created some SQL Stored Procedures in a DB2 environment running on i5OS V5R4. I am nesting them to be able to perform a load of an ODS. The question I have is how to handle a Unit of Work for the whole process when I am calling multiple other stored procedures from the main one. In this situation does each procedure have it's own Unit of Work or can I get all of the called procedures to act in one master Unit of Work so that if any piece errors, I can roll the whole process back?

Thanks,
Douglas

It depends on the OPTION COMMIT value specified on the procedure. You can make them all part of one big transaction or one or more of them independent of the others.

Where is a good source of documentation on these 'options' and how to use them? I have the SQL reference, but didn't see anything in there.

Thanks for the response.

Douglas

I would start here

http://www.redbooks.ibm.com/redbooks...tml/wwhelp.htm