A transaction is started when an SQL statement of the UAP is executed and is terminated when a COMMIT or ROLLBACK statement is executed. Any number of transactions can be started and terminated while the UAP is connected to the HiRDB system.

The following figure shows examples of transaction startup and termination.

Figure 3-6 Examples of transaction startup and termination

In a HiRDB/Parallel Server, processing of SQL statements is branched to multiple servers; but a process is managed as one transaction, and you do not need to consider the internal branches.