Transaction Block

Prev Next

The Block Property window for a Transaction Block is shown below:.

Ref

Description

A

When Atomic Unit of Work is checked, all blocks within the transaction block are treated as atomic unit of work. Generally, multiple update SQL statements can be executed within an atomic unit of work. Nested transactions are not supported. If Atomic Unit of Work is unchecked, all steps in the Transaction block are performed in single database connection to provide read consistency level of isolation.

B

Use the Add a Note field to describe the block’s purpose or functionality for easy reference.