HP 3000 Manuals HP 3000 Manuals
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