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 10.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 | [set pd_hb_ary_fec_num = number of rows-to-be-fetched-at-once-with-FETCH-facility-that-uses-array] | FETCH |
12 | [putenv PDCURSORLVL 0 | 1 | 2 ] | |
13 | putenv PDHOST foreign-HiRDB-host-name[,foreign-HiRDB-secondary-system-host-name] | Connection to a foreign server |
14 | [putenv PDFESHOST foreign-HiRDB-front-end-server-host-name[:foreign-HiRDB-front-end-server-port-number][,foreign-HiRDB-secondary-system-front-end-server-host-name[:foreign-HiRDB-secondary-system-front-end-server-host-name]]] | |
15 | putenv PDNAMEPORT foreign-HiRDB-port-number | |
16 | [putenv PDSERVICEPORT foreign-HiRDB-high-speed-connection-port-number[,foreign-HiRDB-secondary-system-high-speed-connection-port-number]] | |
17 | [putenv PDSERVICEGRP foreign-HiRDB-server-name] | |
18 | [putenv PDSRVTYPE WS | PC] | |
19 | [putenv PDCLTRCVPORT receive-port-range-to-be-reserved] | |
20 | [putenv PDCLTRCVADDR back-end-server-IP-address-or-host-name-for-connecting-to-foreign-server] | |
21 | [putenv PDAUTORECONNECT YES | NO] | |
22 | [putenv PDRCCOUNT maximum-number-of-CONNECT-retries-using-automatic-reconnect-facility] | |
23 | [putenv PDRCINTERVAL CONNECT-retry-interval-for-using-automatic-reconnect-facility] | |
24 | [putenv PDDBLOG ALL | NO] | Database update log |
25 | [putenv PDCLTGRP client-group-name] | Client group |
26 | [putenv PDIPC MEMORY | DEFAULT] | Communication processing |
27 | [putenv PDSENDMEMSIZE memory-size-for-sending-data] | |
28 | [putenv PDRECVMEMSIZE memory-size-for-receiving-data] | |
29 | [putenv PDTCPCONOPT 0 | 1] | |
30 | [putenv PDKALVL 0 | 1 | 2] | |
31 | [putenv PDKATIME interval-for-sending-packets-to-foreign-HiRDB] | |
32 | [putenv PDNODELAYACK YES | NO] | |
33 | [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 |
34 | [putenv PDSWAITTIME [maximum-wait-time-1-for-foreign-HiRDB][,maximum-wait-time-2-for-foreign-HiRDB]] | |
35 | [putenv PDCLTPATH SQL-trace-file-and-error-log-file-output-destination-directory] | Troubleshooting information |
36 | [putenv PDSQLTRACE SQL-trace-file-size] | |
37 | [putenv PDSQLTEXTSIZE size-of-SQL-statements-to-be-output-to-SQL-trace-file] | |
38 | [putenv PDSQLEXECTIME YES | NO] | |
39 | [putenv PDUAPERLOG error-log-file-size] | |
40 | [putenv PDPRMTRC YES | NO] | |
41 | [putenv PDPRMTRCSIZE maximum-data-size-of-?-parameter-information-inside-SQL-trace] | |
42 | [putenv PDTRCMODE ERR | NONE] | |
43 | [putenv PDTRCPATH dynamic-SQL-trace-file-output-destination-directory] | |
44 | [putenv PDUAPREPLVL [s][u][p][r] | a] | |
45 | [putenv PDREPPATH UAP-statistical-report-output-destination-directory] | |
46 | [putenv PDSQLTRCOPENMODE CNCT | SQL] | |
47 | [putenv PDVWOPTMODE access-path-information-acquisition-mode] | |
48 | [putenv PDLOCKLIMIT upper-limit-for-lock-requests-to-foreign-HiRDB] | Lock |
49 | [putenv PDDBACCS RDAREA-generation-number-of-foreign-HiRDB] | Inner replica facility |
50 | [putenv PDDBORGUAP YES | NO] | |
51 | [putenv PDSQLOPTLVL SQL-optimization-option-for-foreign-HiRDB[,SQL-optimization-option-for-foreign-HiRDB]...] | SQL optimization |
52 | [putenv PDADDITIONALOPTLVL SQL-extension-optimization-option-for-foreign-HiRDB[,SQL-extension-optimization-option-for-foreign-HiRDB]...] | |
53 | [putenv PDAGGR number-of-groups-generated-for-foreign-HiRDB-grouping] | |
54 | [putenv PDHASHTBLSIZE hash-table-size-for-hash-join-subquery-hash-execution-by-foreign-HiRDB] | |
55 | [putenv PDUAPEXERLOGUSE YES | NO] | Facility for output of extended SQL error information |
56 | [putenv PDUAPEXERLOGPRMSZ maximum-data-size-of-parameter-information-to-be-output-to-error-log-file-and-SQL-error-report-file] | |
57 | [putenv PDBESCONHOLD YES | NO] | BES connection holding facility |
58 | [putenv PDBESCONHTI back-end-server-connection-hold-time] | |
59 | [putenv PDHATRNQUEUING NO] | System switchover facility |