13.1 Operand formats

The Hub optimization information definition defines whether to execute each syntax of an input query with a foreign server. This definition minimizes the functional differences between HiRDB and a foreign server. When the values specified in the Hub optimization information definition are modified, incompatible facilities produce invalid results. Furthermore, syntaxes not supported by the foreign server may cause errors in the foreign server. Therefore, Hitachi recommends that you use the values explained in 13.4 Recommended values for various foreign servers without any modifications.

Note that the numbers in the following table correspond to the numbers assigned to the operands explained in 13.2 Operand explanations.

[Figure]Operands you can modify before restarting HiRDB
You can modify all operands in the Hub optimization information definition before restarting HiRDB (following planned termination, forced termination, or abnormal termination).
No.Format
1[set pd_hub_opt_on_cnd = 1 - 2]
2[set pd_hub_opt_joined_table = 1 - 3]
3[set pd_hub_opt_set_func = 1 - 4]
4[set pd_hub_opt_case = 1 - 2]
5[set pd_hub_opt_like = 1 - 4]
6[set pd_hub_opt_grouping = 1 - 4]
7[set pd_hub_opt_data_len = 1 - 2147483647​]
8[set pd_hub_opt_abs = 1 - 3]
9[set pd_hub_opt_date = 1 - 3]
10[set pd_hub_opt_time = 1 - 2]
11[set pd_hub_opt_digits = 1 - 2]
12[set pd_hub_opt_length = 1 - 8]
13[set pd_hub_opt_lower_upper_type = 1 - 8]
14[set pd_hub_opt_mod_div_type = 1 - 3]
15[set pd_hub_opt_substr = 1 - 3]
16[set pd_hub_opt_num = 1 - 2]
17[set pd_hub_opt_datetime = 1 - 2]
18[set pd_hub_opt_datetime_op = 1 - 5]
19[set pd_hub_opt_trailing_spc = 1 - 2]
20[set pd_hub_opt_nullable = 1 - 2]
21[set pd_hub_opt_use_zero_string = 1 - 2]
22[set pd_hub_opt_nchar = 1 - 2]
23[set pd_hub_opt_nest_scalar = 0 - 65535]
24[set pd_hub_opt_float = 1 - 2]
25[set pd_hub_opt_table_num = 0 - 65535]
26[set pd_hub_opt_time_24hour = 1 - 2]