A UTM-ESQL program unit is structured like a normal UTM program unit.
To communicate with databases you can use all the facilities of the ESQL interface.
However, for transaction logging you may only use KDCS calls.
ESQL calls such as BEGIN WORK, COMMIT WORK and ROLLBACK WORK are not permitted during the coordinated interaction of openUTM with databases. For further details refer to the manual for your database system.
Currently, Oracle cannot migrate open cursors when connected via XA, i.e. you have to open them explicitly at the start of every program unit and close them explicitly at the end of every program unit. If you require this position in a follow-up program unit, you must program your application to save its value (e.g. in the KB or LSSB) an then set it in the follow-up program unit.
Figure: Example for use of CLOSE CURSOR