Unit of work
Because package creation implicitly performs a commit or rollback, the commit definition must be at a unit of work boundary before the package creation is attempted.
The following conditions must all be true for a commit definition to be at a unit of work boundary:
- SQL is at a unit of work boundary.
- There are no local or DDM files open using commitment control and no closed local or DDM files with pending changes.
- There are no API resources registered.
- There are no LU 6.2 resources registered that are not associated with DRDA® or DDM.
Parent topic:
Considerations for creating an SQL package