Linking to the HiRDB External Data Access facility

When the HiRDB External Data Access facility is used, the HiRDB interface can be used to access the tables of multiple databases constructed from other database management systems, including products of other companies. Also, when multiple databases of other types exist, their information can be viewed and updated as one table using foreign table or view table. To use the HiRDB External Data Access facility, HiRDB External Data Access is required.

The HiRDB External Data Access facility can be used only with the HiRDB/Parallel Server.

Organization of this section: (1) HiRDB system definition specifications; (2) Environment definition specification

(1) HiRDB system definition specifications

The following operands and definition statements are specified in the HiRDB system definition:

pd_max_foreign_server operand
Specifies the maximum number of foreign servers that can be linked.
pdhubopt operand
Specifies the foreign servers to which Hub optimization information definition is applicable.
pd_foreign_server_libpath operand
Specifies the path names of the client libraries of the foreign servers.
Environment variables required for foreign servers
The environment variables required for foreign servers are specified in the back-end server definition.
Foreign server information definition
Hub optimization information definition

In addition to the operands above, you should also consider the specification of the following operand:

pdstbegin operand
Specifies whether or not the following statistical information related to the HiRDB External Data Access facility is to be collected:
- Statistical information related to the operation of foreign servers
- Statistical information related to the usage status of foreign servers

(2) Environment definition specification

For details about the system environment definition in conjunction with using the HiRDB External Data Access facility, see the manual HiRDB External Data Access Version 7 Description and User's Guide.

7.3 Linking to the HiRDB External Data Access facility

(1) HiRDB system definition specifications

(2) Environment definition specification