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.

Figure 3-6 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.