When you are using multiconnect functionality, the SET MULTITRANSACTION
statement provides the capability of switching between
single-transaction mode and multitransaction mode.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
|
SET MULTITRANSACTION { ON OFF }
Parameters |
|
- ON
enables multiple implied or
explicit BEGIN WORK statements to be active across the set of
connected DBEnvironments.
This is termed multitransaction mode.
- OFF
permits one implied or explicit BEGIN WORK statement to be active
across the set of connected DBEnvironments.
This is termed single-transaction mode. This is the default.
Description |
|
A given SET MULTITRANSACTION statement is in effect until another
such statement is issued or until the application (or ISQL) terminates.
Single-transaction mode is the default.
While in single-transaction mode, the SET MULTITRANSACTION ON
statement is always valid.
While in multitransaction mode, the SET MULTITRANSACTION OFF
statement is valid only if no more than one transaction is active.
If an active transaction exists, it must be in the currently connected
DBEnvironment, otherwise the SET MULTITRANSACTION OFF statement
will be rejected and an error will be generated.
No stored section is created for the SET MULTITRANSACTION statement.
SET MULTITRANSACTION cannot be used with the PREPARE or EXECUTE IMMEDIATE
statements or in procedures.
An active transaction is not required to execute a SET MULTITRANSACTION
statement. An automatic transaction will not be started when executing
a SET MULTITRANSACTION statement.
Authorization |
|
You do not need authorization to use the SET MULTITRANSACTION statement.
Example |
|
Put single-transaction mode in effect:
Put multitransaction mode in effect:
