This section explains the transaction control that is performed when a HiRDB database is accessed from a UAP. A transaction is a logical unit of work. In the case of HiRDB, transaction control has the following meaning:

Transaction control unique to HiRDB

This encompasses transactions that are within the range of HiRDB specifications, and refers to processing in which either a COMMIT or a ROLLBACK statement is issued by an SQL statement to determine whether an updating of table data is to be put into effect or is to be invalidated.

Transaction control based on XA interface

This applies to a transaction that is executed by UAP processing when linkage to OLTP is established using the XA interface; it refers to the process that determines whether the UAP processing under OLTP using an XA interface function (the tx_commit or tx_rollback function) is to be put into effect or is to be invalidated.

Organization of this section

6.9.1 Connection to and disconnection from HiRDB

6.9.2 Multi-connection facility

6.9.3 Transaction startup and termination

6.9.4 Commit and rollback

6.9.5 UAP transaction management under OLTP environment

6.9.6 Automatic reconnect facility