13.4 Recommended values for various foreign servers

This section explains the recommended values of the operands for various types of foreign servers.

The values in the Hub optimization information definition sample file are the same as the values recommended here. Therefore, use the values in the Hub optimization information definition sample file without any modification. For the storage location of the Hub optimization information definition sample file, see the HiRDB External Data Access Version 7 Description and User's Guide.

Operand nameHiRDB Version 6 or laterHiRDB Version 5.0XDM/RD E2ORACLE
pd_hub_opt_on_cnd1112
pd_hub_opt_joined_table1312
pd_hub_opt_set_func1331
pd_hub_opt_case1112
pd_hub_opt_like11144
pd_hub_opt_grouping1143
pd_hub_opt_data_len2255255255255
pd_hub_opt_abs1113
pd_hub_opt_date1113
pd_hub_opt_time1112
pd_hub_opt_digits1112
pd_hub_opt_length1137
pd_hub_opt_lower_upper_type1116
pd_hub_opt_mod_div_type1121
pd_hub_opt_substr1132
pd_hub_opt_num1112
pd_hub_opt_datetime1112
pd_hub_opt_datetime_op1115
pd_hub_opt_trailing_spc1111
pd_hub_opt_nullable1112
pd_hub_opt_use_zero_string1112
pd_hub_opt_nchar21122
pd_hub_opt_nest_scalar0000
pd_hub_opt_float2222
pd_hub_opt_table_num64646464
pd_hub_opt_time_24hour1111
1 If a LIKE predicate, NOT LIKE predicate, XLIKE predicate, or NOT XLIKE predicate for the character string-type, variable-size character string-type, mixed character string-type, or variable-size mixed character string-type data contains two-byte special characters, or if a LIKE predicate, NOT LIKE predicate, XLIKE predicate, or NOT XLIKE predicate for the national character string-type or variable-size national character string-type data contains one-byte special characters, do not execute these predicates using the foreign server.
2 If the national character-type character code set of the foreign server is not fixed to 2 bytes, specify 2.