Previous Topic Next topic Print topic


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}

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.

Previous Topic Next topic Print topic