Controlling Transactions

Controlling Transactions

Defining Transaction Modes

AUTOCOMMIT determines whether to automatically commit the results of a command at the time of execution.

AUTOCOMMIT OFF;

- Commands are not automatically committed before being manually committed by the user.

AUTOCOMMIT ON;

- Commands are automatically committed at the time of execution.

PLANCOMMIT

SET PLANCOMMIT ON/OFF;

When EXPLAIN PLAN has been set to ON or ONLY, there is the possibility that the iSQL commands DESC; SELECT * FROM TAB; or SELECT * FROM SEQ; will be committed, even if AUTOCOMMIT has been set to OFF. This setting determines whether to commit them automatically.

Note: This setting has been provided to overcome the misunderstanding where the user believes that such a command has not been prepared, but the system prepares the command in order to generate the execution plan. The command would then be committed, without the user knowing it, when a COMMIT command is executed later. When this value is OFF (which is the default) in a session for which EXPLAIN PLAN is ON (or ONLY) and AUTOCOMMIT is OFF, Altibase does not autocommit the above commands (DESC, SELECT * FROM tab; or SELECT * FROM seq;). When this value is ON, iSQL issues a special commit command to commit these commands.