|
|
When you are using multiconnect functionality, the SET MULTITRANSACTION
statement provides the capability of switching between
single-transaction mode and multitransaction mode.
ISQL or Application Programs
SET MULTITRANSACTION {ON
OFF}
- 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.
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.
You do not need authorization to use the SET MULTITRANSACTION statement.
Put single-transaction mode in effect:
SET MULTITRANSACTION OFF
Put multitransaction mode in effect:
SET MULTITRANSACTION ON
|