Specifying client environment definitions for foreign table access

When the foreign server is a HiRDB or XDM/RD E2 server and a foreign table is to be accessed, the specification values of some client environment definitions also apply to the foreign server. There are also client environment definitions for which fixed values are always applied to the foreign server.

Foreign tables can be accessed (the HiRDB External Data Access facility can be used) when the HiRDB is the HP-UX or AIX 5L version.

Organization of this subsection: (1) When the foreign server is a HiRDB server; (2) When the foreign server is an XDM/RD E2 server

(1) When the foreign server is a HiRDB server

(a) Client environment definitions for which specification values are applied

The specification values of the following client environment definitions are also applied to the foreign HiRDB server:

PDISLLVL
PDCLTAPNAME^*
PDEXWARN^*
PDDLKPRIO^*
PDLOCKSKIP^*
PDCWAITTIMEWRNPNT^*

^* The specification value is applied if the foreign HiRDB is Version 06-02 or later.

(b) Client environment definitions for which fixed values are applied

For the following client definitions, fixed values are applied to the external HiRDB server:

PDSTJTRNOUT (fixed value: NO)
PDDFLNVAL (fixed value: NOUSE)
PDSWATCHTIME (fixed value: 0)
PDAUTOCONNECT (fixed value: OFF)

(2) When the foreign server is an XDM/RD E2 server

(a) Foreign environment definition for which a fixed value is applied

For the following client environment definition, a fixed value is applied to the foreign XDM/RD E2 server:

PDSRVTYPE (fixed value: VOS3)

6.6.6 Specifying client environment definitions for foreign table access

(1) When the foreign server is a HiRDB server

(a) Client environment definitions for which specification values are applied

(b) Client environment definitions for which fixed values are applied

(2) When the foreign server is an XDM/RD E2 server

(a) Foreign environment definition for which a fixed value is applied