SET MULTITRANSACTION

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:

SET MULTITRANSACTION OFF

Put multitransaction mode in effect:

SET MULTITRANSACTION ON