TRANSACTION Command

TRANSACTION — Safeley execute SQL command within a transaction environment.

Synopsis

TRANSACTION BEGIN data_source_name [ ISOLATION { ReadCommitted | ReadUncommitted | RepeatableRead | Serializable | Unknown } ]

TRANSACTION COMMIT data_source_name

TRANSACTION ROLLBACK data_source_name

Introduction

The TRANSACTION command provides a transaction environment where within SQL commands can be executed safeley. Transactions will only work if the underlying tables are transaction safe tables.

Arguments

data_source_name

The name of the data source as defined in the development environment.

Note

In case no ISOLATION level has been entered, the default of Serializable will be used.

Example

. . .
. . .
TRANSACTION BEGIN Order ISOLATION Serializable
. . .
. . .
TRANSACTION COMMIT Order
. . .
. . .

Related Commands

SQL

ProLinga