A UAP of a single HiRDB client can connect simultaneously to multiple HiRDB servers. This is called the multi-connection facility. The multi-connection facility enables a single application process at a HiRDB client to make multiple connections to a single HiRDB server. A single application process can also connect to multiple HiRDB servers. Each of the multiple connections is treated as an independent transaction (i.e., it is handled by the HiRDB server as though each connection were made from a separate process). Because a single UAP can make multiple connections, the number of UAPs to be executed can be reduced, thus reducing the overall memory requirements of the UAPs.

To use the multi-connection facility, a dedicated library that is provided must be linked. For details about the multi-connection facility, see the HiRDB Version 8 UAP Development Guide.

Setting up the multi-connection facility

The multi-connection facility is used by defining the following SQLs in the UAP definition:

• Allocation of a connection handle (ALLOCATE CONNECTION HANDLE statement)
• Declaration of connection handle setup (DECLARE CONNECTION HANDLE SET statement)
• Cancellation of connection handle setup (DECLARE CONNECTION HANDLE UNSET statement)
• Release of connection handle (FREE CONNECTION HANDLE statement)