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

This example creates system definitions for a HiRDB/Parallel Server when the HiRDB External Data Access is being used. Note that in this definition example, only those operands that are related to the HiRDB External Data Access facility are explained.

[Figure]

Organization of this subsection
(1) System common definition
(2) Front-end server definition (FES1)
(3) Front-end server definition (FES2)
(4) Back-end server definition (BES1)
(5) Back-end server definition (BES2)
(6) Foreign server information definition (for HiRDB Version 6)
(7) Foreign server information definition (for XDM/RD E2)
(8) Hub optimization information definition (for HiRDB Version 6)
(9) Hub optimization information definition (for XDM/RD E2)

(1) System common definition

        :
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
  1. Specifies the host name of the foreign server (HiRDB Version 6).
  2. 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
  1. Specifies the host name of the DB connection server.
  2. Specifies the port number of the DB connection server.
  3. 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