This directive provides OpenESQL with specifications for managing run-time transactions and, in some cases, enabling compile-time checking.
Syntax:
TRANSACTION={GLOBAL | LOCAL | MIXED}
Parameters:
| GLOBAL
|
Manages transactions using a distributed transaction manager such as CICS, Tuxedo, or COM+.
When BEHAVIOR=CICS, this parameter also:
- Checks for the following statements that are not compatible with CICS applications:
- BEGIN TRANSACTION
- COMMIT
- CONNECT
- DISCONNECT
- ROLLBACK
- SET AUTOCOMMIT
- SET CONNECT
- SET TRANSACTION [ISOLATION]
- Reports an error for each incompatible statement found.
|
| LOCAL
|
Manages transactions using the data source (default).
When BEHAVIOR=JCL, the default behavior includes:
- Checks for the following statements that are not compatible with JCL applications:
- CONNECT
- DISCONNECT
- SET CONNECT
- Reports an error for each incompatible statement found.
|
| MIXED
|
Manages transactions using a distributed transaction manager, but does not perform compile-time checking. Use this option when you need to mix GLOBAL and LOCAL transaction behavior with different data sources.
|
Scope:
| Used at compile time:
|
Yes
|
| Behavior at run time:
|
N/A
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.