Quote:
Originally Posted by umayer
the manual states about the explicit COMMIT statement in V9 (z/OS):
Restrictions on the use of COMMIT:
The COMMIT statement cannot be used in a stored procedure if the procedure is in the calling chain of a user-defined function or a trigger or DB2 is not the commit coordinator.
|
I beleive that it also states that a COMMIT cannot be used in a CICS or IMS environment, which I assume means when SP's are called from CICS or IMS programs. But cse_gokul is using J2EE so I assume it is OK in that case.