12.1 Operand formats

The foreign server information definition defines the execution environment for the HiRDB External Data Access facility. Note that the numbers in the following table correspond to the numbers assigned to the operands explained in 12.2 Operand explanations. Note that in addition to the foreign server information definition, you also need an ORACLE client definition. For details, see the ORACLE documentation.

[Figure]To users who are creating a foreign server information definition for the first time
First, determine the values to be specified for the operands shown in bold. Basically, once you specify these operands, you can use the HiRDB External Data Access facility.
[Figure]Operands you can modify before restarting HiRDB
You can modify all operands in the foreign server information definition before restarting HiRDB (following planned termination, forced termination, or abnormal termination).
No.FormatOperand category
1[set pd_hb_db_con = STARTUP | ACCESS ]Connection to and disconnection from a foreign server
2[set pd_hb_db_dis_con = SHUTDOWN | COMMIT ]
3[set pd_hb_e_mode = ALL | NONE ]Foreign server error information
4[set pd_hb_e_code = SQLCODE[,SQLCODE]...]
5[set pd_hb_e_size = foreign-server-error-information-file-size]
6[set pd_hb_l_path = foreign-server-interface-trace-information-file-output-destination-directory]Foreign server interface trace information
7[set pd_hb_l_size = foreign-server-interface-trace-information-file-size]
8[set pd_hb_l_prm = Y | N ]
9[set pd_hb_l_prm_size = maximum-data-size-of-?-parameter-information-to-be-output-to foreign-server-interface-trace-information-file]
10[set pd_hb_l_mode = ALL | PARTIAL]
11[set pd_hb_ary_fec_num = number of rows-to-be-fetched-at-once-with-FETCH-facility-that-uses-array]FETCH
12[set pd_hb_sql_trace = Y | N ]Troubleshooting information
13[set pd_hb_get_lock = Y | N ]Lock
14[set pd_hb_use_describe = Y | N ]DESCRIBE statement
15putenv PDNETSERVICE net-service-name-of-database-to-be-connectedConnection to a foreign server