ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 529
SQL Statements S - Z
SET MULTITRANSACTION
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.