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 name | HiRDB Version 6 or later | HiRDB Version 5.0 | XDM/RD E2 | ORACLE |
---|---|---|---|---|
pd_hub_opt_on_cnd | 1 | 1 | 1 | 2 |
pd_hub_opt_joined_table | 1 | 3 | 1 | 2 |
pd_hub_opt_set_func | 1 | 3 | 3 | 1 |
pd_hub_opt_case | 1 | 1 | 1 | 2 |
pd_hub_opt_like1 | 1 | 1 | 4 | 4 |
pd_hub_opt_grouping | 1 | 1 | 4 | 3 |
pd_hub_opt_data_len2 | 255 | 255 | 255 | 255 |
pd_hub_opt_abs | 1 | 1 | 1 | 3 |
pd_hub_opt_date | 1 | 1 | 1 | 3 |
pd_hub_opt_time | 1 | 1 | 1 | 2 |
pd_hub_opt_digits | 1 | 1 | 1 | 2 |
pd_hub_opt_length | 1 | 1 | 3 | 7 |
pd_hub_opt_lower_upper_type | 1 | 1 | 1 | 6 |
pd_hub_opt_mod_div_type | 1 | 1 | 2 | 1 |
pd_hub_opt_substr | 1 | 1 | 3 | 2 |
pd_hub_opt_num | 1 | 1 | 1 | 2 |
pd_hub_opt_datetime | 1 | 1 | 1 | 2 |
pd_hub_opt_datetime_op | 1 | 1 | 1 | 5 |
pd_hub_opt_trailing_spc | 1 | 1 | 1 | 1 |
pd_hub_opt_nullable | 1 | 1 | 1 | 2 |
pd_hub_opt_use_zero_string | 1 | 1 | 1 | 2 |
pd_hub_opt_nchar2 | 1 | 1 | 2 | 2 |
pd_hub_opt_nest_scalar | 0 | 0 | 0 | 0 |
pd_hub_opt_float | 2 | 2 | 2 | 2 |
pd_hub_opt_table_num | 64 | 64 | 64 | 64 |
pd_hub_opt_time_24hour | 1 | 1 | 1 | 1 |