TRANSACTION

This directive provides OpenESQL with specifications for managing run-time transactions and, in some cases, enabling compile-time checking.

Syntax:

TRANSACTION={GLOBAL | LOCAL | MIXED}

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.

Used at compile time:	Yes
Behavior at run time:	N/A

See Scope - OpenESQL SQL Compiler Directive Options for more information.