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 11.2 Operand explanations.
No. | Format | Operand 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 | putenv PDCLTRDNODE XDM/RD-E2-database-identifier | Connection to a foreign server |
12 | putenv PDHOST DB-connection-server-host-name[,secondary-system-host-name] | |
13 | putenv PDNAMEPORT DB-connection-server-port-number | |
14 | [putenv PDCWAITTIME [maximum-wait-time-1-for-HiRDB-client-used-by-HiRDB-External-Data-Access-Adapter][,maximum-wait-time-2-for-HiRDB-client-used-by-HiRDB-External-Data-Access-Adapter]] | System monitoring |
15 | [putenv PDCLTPATH SQL-trace-file-and-error-log-file-output-destination-directory] | Troubleshooting information |
16 | [putenv PDSQLTRACE SQL-trace-file-size] | |
17 | [putenv PDUAPERLOG error-log-file-size] | |
18 | [putenv PDPRMTRC YES | NO ] | |
19 | [putenv PDPRMTRCSIZE maximum-data-size-of-?-parameter-information-inside-SQL-trace] | |
20 | [putenv PDBLKF number-of-block-transfer-rows-of-search-result-to-be-sent-from-XDM/RD-E2] | Data transfer |