Example 6 (when the HiRDB External Data Access facility is used)

         :
set pd_max_foreign_server = 2

Explanation: Specifies the (maximum) number of foreign servers.

(2) Front-end server definition (FES1)

         :
pdhubopt -s hirdb_v6_01 -f hubopt1
pdhubopt -s xdmrd_01 -f hubopt2

Explanation: Defines that HiRDB Version 6 (server name: hirdb_v6_01) and XDM/RD E2 (server name: xdmrd_01) are used as foreign servers. A Hub optimization information definition file name is specified for the -f option.

(3) Front-end server definition (FES2)

         :
pdhubopt -s hirdb_v6_01 -f hubopt1
pdhubopt -s xdmrd_01 -f hubopt2

Explanation: Defines that HiRDB Version 6 (server name: hirdb_v6_01) and XDM/RD E2 (server name: xdmrd_01) are used as foreign servers. A Hub optimization information definition file name is specified for the -f option.

(4) Back-end server definition (BES1)

         :
set pd_foreign_server_libpath = "C:\hirdb\client\lib"

Explanation: Specifies the absolute path name of the client library of the foreign server (HiRDB Version 6).

(5) Back-end server definition (BES2)

         :
set pd_foreign_server_libpath = "C:\hirdb\client\lib"

Explanation: Specifies the absolute path name of the client library of the foreign server (XDM/RD E2).

(6) Foreign server information definition (for HiRDB Version 6)

 
putenv PDHOST host01                                       1
putenv PDNAMEPORT 20000                                    2

Explanation

Specifies the host name of the foreign server (HiRDB Version 6).
Specifies the port number of the foreign server (HiRDB Version 6).

(7) Foreign server information definition (for XDM/RD E2)

 
putenv PDHOST host02                                       1
putenv PDNAMEPORT 20100                                    2
putenv PDCLTRDNODE rd_node1                                3

Explanation

Specifies the host name of the DB connection server.
Specifies the port number of the DB connection server.
Specifies the RD node name of the foreign server (XDM/RD E2).

(8) Hub optimization information definition (for HiRDB Version 6)

Hub optimization information definition file name: hubopt1

 
set pd_hub_opt_on_cnd =1
set pd_hub_opt_joined_table =1
set pd_hub_opt_set_func = 1
set pd_hub_opt_case = 1
set pd_hub_opt_like = 1
set pd_hub_opt_grouping = 1
set pd_hub_opt_data_len = 255
set pd_hub_opt_abs = 1
set pd_hub_opt_date = 1
set pd_hub_opt_time = 1
set pd_hub_opt_digits = 1
set pd_hub_opt_length = 1
set pd_hub_opt_lower_upper_type = 1
set pd_hub_opt_mod_div_type = 1
set pd_hub_opt_substr = 1
set pd_hub_opt_num = 1
set pd_hub_opt_datetime = 1
set pd_hub_opt_datetime_op = 1
set pd_hub_opt_trailing_spc = 1
set pd_hub_opt_nullable = 1
set pd_hub_opt_use_zero_string = 1
set pd_hub_opt_nchar = 1
set pd_hub_opt_nest_scalar = 0
set pd_hub_opt_float = 2
set pd_hub_opt_table_num = 64
set pd_hub_opt_time_24hour = 1

(9) Hub optimization information definition (for XDM/RD E2)

Hub optimization information definition file name: hubopt2

 
set pd_hub_opt_on_cnd =1
set pd_hub_opt_joined_table =1
set pd_hub_opt_set_func = 3
set pd_hub_opt_case = 1
set pd_hub_opt_like = 4
set pd_hub_opt_grouping = 4
set pd_hub_opt_col_len = 255
set pd_hub_opt_abs = 1
set pd_hub_opt_date = 1
set pd_hub_opt_time = 1
set pd_hub_opt_digits = 1
set pd_hub_opt_length = 3
set pd_hub_opt_lower_upper_type = 1
set pd_hub_opt_mod_div_type = 2
set pd_hub_opt_substr = 3
set pd_hub_opt_num = 1
set pd_hub_opt_datetime = 1
set pd_hub_opt_datetime_op = 1
set pd_hub_opt_trailing_spc = 1
set pd_hub_opt_nullable = 1
set pd_hub_opt_use_zero_string = 1
set pd_hub_opt_nchar = 2
set pd_hub_opt_nest_scalar = 0
set pd_hub_opt_float = 2
set pd_hub_opt_table_num = 64
set pd_hub_opt_time_24hour = 1

Appendix C.6 Example 6 (when the HiRDB External Data Access facility is used)

(1) System common definition