Transaction Name

The optional NAME attribute defines the name of a transaction.Use of this attribute is available only in Embedded SQL (ESQL).In ESQL applications, named transactions make it possible to have several transactions active simultaneously in one application.If named transactions are used, a host-language variable with the same name must be declared and initialized for each named transaction.This is a limitation that prevents dynamic specification of transaction names and thus rules out transaction naming in DSQL.

Transaction Parameters

The main parameters of a transaction are:

data access mode (READ WRITE, READ ONLY)
lock resolution mode (WAIT, NO WAIT) with an optional LOCK TIMEOUT specification

isolation level (READ COMMITTED, SNAPSHOT, SNAPSHOT TABLE STABILITY).

Note	The `READ UNCOMMITTED` isolation level is a synonym for `READ COMMITTED`, and is provided only for syntax compatibility.It provides identical semantics as `READ COMMITTED`, and does not allow you to view uncommitted changes of other transactions.

a mechanism for reserving or releasing tables (the RESERVING clause)