To execute commands and utilities, add the following directory to the PATH environment variable:

• Executing a client on the server machine
  

  /opt/HiRDB/client/utl/

• Logging into the HiRDB server from a remote system
  

  $PDDIR/client/utl/

• Retrieval sequence for client environment definitions
  If the client environment definitions are set at several locations, each client environment definition is retrieved in the sequence below. If a client environment definition has no specified value, the default value is applied.
  
  1. Environment variables group^*
  2. User environment variables

  * When the multi-connection facility is used, use ALLOCATE CONNECTION HANDLE to specify the file name. If a UAP under OLTP is used as the client, specify the file name in an open character string. For details about open character strings, see the HiRDB Version 8 Installation and Design Guide.

(a) sh (Bourne shell)

You must store the environment variables shown below in the .profile file. These environment variables execute automatically at the time of startup.

  $ PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
  $ PDNAMEPORT=HiRDB-server-port-number
  $ PDFESHOST=front-end-server-host-name
            [:port-number-of-unit-containing-front-end-server]
               [,secondary-system-front-end-server-host-name
               [:port-number-of-unit-containing-secondary-system-front-end-server]]
  $ PDSERVICEGRP=server-name
  $ PDSRVTYPE={WS|PC}
  $ PDSERVICEPORT=high-speed-connection-port-number
                [,secondary-system-high-speed-connection-port-number]
  $ PDFESGRP=FES-group[,switchover-FES-group[,switchover-FES-group]...]
  $ PDCLTRCVPORT=client-receive-port-number
  $ PDCLTRCVADDR={client-IP-address|client-host-name}
  $ PDTMID=OLTP-identifier
  $ PDXAMODE={0|1}
  $ PDTXACANUM=maximum-number-of-concurrent-transaction-executions-per-process
  $ PDXARCVWTIME=transaction-recovery-wait-time
  $ PDXATRCFILEMODE={LUMP|SEPARATE}
  $ HiRDB_PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
  $ HiRDB_PDNAMEPORT=HiRDB-server-port-number
  $ HiRDB_PDTMID=OLTP-identifier
  $ HiRDB_PDXAMODE={0|1}
  $ PDUSER=[authorization-identifier/password]
  $ PDCLTAPNAME=identification-name-of-UAP-to-be-executed
  $ PDCLTLANG={SJIS|CHINESE|UJIS|C}
  $ PDLANG={UTF-8|SJIS|CHINESE|ANY}
  $ PDDBLOG={ALL|NO}
  $ PDEXWARN={YES|NO}
  $ PDSUBSTRLEN={3|4|5|6}
  $ PDCLTCNVMODE={AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|
   UTF8_TXT|UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|
   UCS2_UTF8}
  $ PDCLTGAIJIDLL=user-defined-external-character-conversion-DLL-file-name
  $ PDCLTGAIJIFUNC=user-defined-external-character-conversion-function-name
  $ PDCLTGRP=client-group-name
  $ PDTCPCONOPT={0|1}
  $ PDAUTORECONNECT={YES|NO}
  $ PDRCCOUNT=CONNECT-retry-count-with-automatic-reconnect-facility
  $ PDRCINTERVAL=CONNECT-retry-interval-with-automatic-reconnect-facility
  $ PDUAPENVFILE=UAP-environment-definition-file-name
  $ PDDBBUFLRU={YES|NO}
  $ PDHATRNQUEUING=NO
  $ PDASTHOST=HiRDB-Control-Manager-Agent-host-name
              [,secondary-system-HiRDB-Control-Manager-Agent-host-name]
  $ PDASTPORT=HiRDB-Control-Manager-Agent-port-number
  $ PDSYSTEMID=HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control-Manager-Agent
  $ PDASTUSER=OS-user-name/password
  $ PDCMDWAITTIME=maximum-client-wait-time-during-command-execution
  $ PDCMDTRACE=command-trace-file-size
  $ PDIPC={MEMORY|DEFAULT}
  $ PDSENDMEMSIZE=data-send-memory-size-in-client
  $ PDRECVMEMSIZE=data-receive-memory-size-in-client
  $ PDCWAITTIME=maximum-client-wait-time
  $ PDSWAITTIME=maximum-server-wait-time-during-transaction-processing
  $ PDSWATCHTIME=maximum-server-wait-time-outside-transaction-processing
  $ PDCWAITTIMEWRNPNT=output-time-for-SQL-runtime-warning
  $ PDKALVL={0|1|2}
  $ PDKATIME=packet-send-interval
  $ PDTIMEDOUTRETRY=retry-count
  $ PDNBLOCKWAITTIME=connection-establishment-monitoring-time-in-nonblock-mode
  $ PDCONNECTWAITTIME=maximum-wait-time-in-HiRDB-client-during-server-connection
  $ PDCLTPATH=trace-file-storage-directory
  $ PDSQLTRACE=SQL-trace-file-size
  $ PDUAPERLOG=error-log-file-size
  $ PDERRSKIPCODE=SQLCODE[,SQLCODE]...
  $ PDPRMTRC={YES|NO|IN|OUT|INOUT}
  $ PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
  $ PDTRCMODE={ERR|NONE}
  $ PDUAPREPLVL={[s][u][p][r]|a}
  $ PDREPPATH=storage-directory-for-UAP-statistical-report-files
  $ PDTRCPATH=storage-directory-for-dynamic-SQL-trace-files
  $ PDSQLTRCOPENMODE={CNCT|SQL}
  $ PDSQLTEXTSIZE=SQL-statement-size
  $ PDSQLEXECTIME={YES|NO}
  $ PDRCTRACE=reconnect-trace-file-size
  $ PDWRTLNPATH=storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
  $ PDWRTLNFILSZ=maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
  $ PDWRTLNCOMSZ=total-size-of-WRITE-LINE-statement-value-expression-values
  $ PDUAPEXERLOGUSE={YES|NO}
  $ PDUAPEXERLOGPRMSZ=maximum-data-length-of-parameter-information
  $ PDVWOPTMODE={0|1|2}
  $ PDTAAPINFPATH=access-path-information-file-output-directory-name
  $ PDTAAPINFMODE={0|1}
  $ PDTAAPINFSIZE=access-path-information-file-size
  $ PDSTJTRNOUT={YES|NO}
  $ PDLOCKLIMIT=maximum-locked-resource-request-count-per-user
  $ PDDLKPRIO={96|64|32}
  $ PDLOCKSKIP={YES|NO}
  $ PDFORUPDATEEXLOCK={YES|NO}
  $ PDISLLVL=data-guarantee-level
  $ PDSQLOPTLVL=SQL-optimization-option[,SQL-optimization-option]...
  $ PDADDITIONALOPTLVL=SQL-extension-optimizing-option
                       [,SQL-extension-optimizing-option]...
  $ PDHASHTBLSIZE=hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
  $ PDDFLNVAL={USE|NOUSE}
  $ PDAGGR=group-count-resulting-from-grouping
  $ PDCMMTBFDDL={YES|NO}
  $ PDPRPCRCLS={YES|NO}
  $ PDAUTOCONNECT={ON|OFF}
  $ PDDDLDEAPRP={YES|NO}
  $ PDCURSORLVL={0|1|2}
  $ PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name
  $ PDHJHASHINGMODE={TYPE1|TYPE2}
  $ PDBLKF=block-transfer-row-count
  $ PDBINARYBLKF={YES|NO}
  $ PDBLKBUFFSIZE=communication-buffer-size
  $ PDNODELAYACK={YES|NO}
  $ PDDBACCS=generation-number-of-RDAREA-to-be-accessed
  $ PDDBORGUAP={YES|NO}
  $ PDSPACELVL={0|1|3}
  $ PDCLTRDNODE=XDM/RD-E2-database-identifier
  $ PDTP1SERVICE={YES|NO}
  $ PDCNSTRNTNAME={LEADING|TRAILING}
  $ PDBESCONHOLD={YES|NO}
  $ PDBESCONHTI=BES-connection-holding-period
  $ PDRDABLKF=batch-retrieval-row-count
  $ PDODBSTATCAHE={0|1}
  $ PDODBESCAPE={0|1}
  $ PDGDATAOPT={YES|NO}
  $ PDODBLOCATOR={YES|NO}
  $ PDODBSPLITSIZE=partition-acquisition-size
  $ PDODBCWRNSKIP={YES|NO}
  $ PDJETCOMPATIBLE={YES|NO}
  $ PDPLGIXMK={YES|NO}
  $ PDPLGPFSZ=initial-size-of-delayed-batch-creation-index-information-file
  $ PDPLGPFSZEXP=extension-value-of-delayed-batch-creation-index-information-file
  
  $ export PDHOST PDNAMEPORT PDFESHOST PDSERVICEGRP PDSRVTYPE
           PDSERVICEPORT PDFESGRP PDCLTRCVPORT PDCLTRCVADDR PDTMID PDXAMODE
           PDTXACANUM PDXARCVWTIME PDXATRCFILEMODE PDUSER
           PDCLTAPNAME PDCLTLANG PDLANG PDDBLOG PDEXWARN PDSUBSTRLEN
           PDCLTCNVMODE PDCLTGAIJIDLL PDCLTGAIJUFUNC PDCLTGRP PDTCPCONOPT
           PDAUTORECONNECT PDRCCOUNT PDRCINTERVAL PDUAPENVFILE
           PDDBBUFLRU PDHATRNQUEUING PDASTHOST PDASTPORT PDSYSTEMID PDASTUSER
           PDCMDWAITTIME PDCMDTRACE PDIPC PDSENDMEMSIZE
           PDRECVMEMSIZE PDCWAITTIME PDSWAITTIME PDSWATCHTIME
           PDCWAITTIMEWRNPNT PDKALVL PDKATIME PDTIMEDOUTRETRY
           PDNBLOCKWAITTIME PDCONNECTWAITTIME PDCLTPATH PDSQLTRACE
           PDUAPERLOG PDERRSKIPCODE PDPRMTRC PDPRMTRCSIZE PDTRCMODE
           PDUAPREPLVL PDREPPATH PDTRCPATH PDSQLTRCOPENMODE PDSQLTEXTSIZE
           PDUAPEXERLOGUSE PSUAPEXERLOGPRMSZ PDVWOPTMODE PDTAAPINFPATH
           PDTAAPINFMODE PDTAAPINFSIZE PDSTJTRNOUT PDLOCKLIMIT PDDLKPRIO
           PDLOCKSKIP PDFORUPDATEEXLOCK PDISLLVL PDSQLOPTLVL
           PDADDITIONALOPTLVL PDHASHTBLSIZE PDDFLNVAL PDAGGR
           PDCMMTBFDDL PDPRPCRCLS PDAUTOCONNECT PDDDLDEAPRP PDCURSORLVL
           PDDELRSVWDFILE PDHJHASHINGMODE PDBLKF PDBINARYBLKF PDBLKBUFFSIZE
           PDNODELAYACK PDDBACCS PDDBORGUAP PDSPACELVL PDCLTRDNODE
           PDTP1SERVICE PDCNSTRNTNAME PDBESCONHOLD PDBESCONHTI PDRDABLKF
           PDODBSTATCAHE PDODBESCAPE PDGDATAOPT PDODBLOCATOR PDODBSPLITSIZE
           PDODBCWRNSKIP PDJETCOMPATIBLE PDPLGIXMK PDPLGPFSZ PDPLGPFSZEXP

(b) csh (C shell)

You must store the environment variables shown below in the .login or .cshrc file. These environment variables execute automatically at the time of startup.

  % setenv PDHOST HiRDB-server-host-name
                  [,secondary-system-HiRDB-server-host-name]
  % setenv PDNAMEPORT HiRDB-server-port-number
  % setenv PDFESHOST front-end-server-host-name
            [:port-number-of-unit-containing-front-end-server]
              [,secondary-system-front-end-server-host-name
              [:host-name-of-unit-containing-secondary-system-front-end-server]]
  % setenv PDSERVICEGRP server-name
  % setenv PDSRVTYPE {WS|PC}
  % setenv PDSERVICEPORT high-speed-connection-port-number
                         [,secondary-system-high-speed-connection-port-number]
  % setenv PDFESGRP FES-group[,switchover-FES-group[,switchover-FES-group]...]
  % setenv PDCLTRCVPORT client-receive-port-number
  % setenv PDCLTRCVADDR {client-IP-address
                         |client-host-name}
  % setenv PDTMID OLTP-identifier
  % setenv PDXAMODE {0|1}
  % setenv PDTXACANUM maximum-concurrent-transaction-execution-count-per-process
  % setenv PDXARCVWTIME transaction-recovery-wait-time
  % setenv PDXATRCFILEMODE {LUMP|SEPARATE}
  % setenv HiRDB_PDHOST HiRDB-server-host-name
                        [,secondary-system-HiRDB-server-host-name]
  % setenv HiRDB_PDNAMEPORT HiRDB-server-port-number
  % setenv HiRDB_PDTMID OLTP-identifier
  % setenv HiRDB_PDXAMODE {0|1}
  % setenv PDUSER authorization-identifier/password
  % setenv PDCLTAPNAME identification-name-of-UAP-to-be-executed
  % setenv PDCLTLANG {SJIS|CHINESE|UJIS|C}
  % setenv PDLANG {UTF-8|SJIS|CHINESE|ANY}
  % setenv PDDBLOG {ALL|NO}
  % setenv PDEXWARN {YES|NO}
  % setenv PDCLTCNVMODE {AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|UTF8_TXT|
   UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|UCS2_UTF8}
  % setenv PDCLTGAIJIDLL user-defined-external-character-conversion-DLL-file-name
  % setenv PDCLTGAIJIFUNC user-defined-external-character-conversion-function-name
  % setenv PDCLTGRP client-group-name
  % setenv PDTCPCONOPT {0|1}
  % setenv PDAUTORECONNECT {YES|NO}
  % setenv PDRCCOUNT CONNECT-retry-count-with-automatic-reconnect-facility
  % setenv PDRCINTERVAL CONNECT-retry-interval-with-automatic-reconnect-facility
  % setenv PDUAPENVFILE UAP-environment-definition-file-name
  % setenv PDDBBUFLRU {YES|NO}
  % setenv PDHATRNQUEUING NO
  % setenv PDASTHOST HiRDB-Control-Manager-Agent-host-name
              [,secondary-system-HiRDB-Control-Manager-Agent-host-name]
  % setenv PDASTPORT HiRDB-Control-Manager-Agent-port-number
  % setenv PDSYSTEMID HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control-Manager-Agent
  % setenv PDASTUSER [OS-user-name/password]
  % setenv PDCMDWAITTIME maximum-client-wait-time-during-command-execution
  % setenv PDCMDTRACE command-trace-file-size
  % setenv PDIPC {MEMORY|DEFAULT}
  % setenv PDSENDMEMSIZE data-send-memory-size-in-client
  % setenv PDRECVMEMSIZE data-receive-memory-size-in-client
  % setenv PDCWAITTIME maximum-client-wait-time
  % setenv PDSWAITTIME maximum-server-wait-time-during-transaction-processing
  % setenv PDSWATCHTIME maximum-server-wait-time-outside-transaction-processing
  % setenv PDCWAITTIMEWRNPNT output-time-for-SQL-runtime-warning
  % setenv PDKALVL {0|1|2}
  % setenv PDKATIME packet-send-interval
  % setenv PDTIMEDOUTRETRY retry-count
  % setenv PDNBLOCKWAITTIME connection-establishment-monitoring-time-in-nonblock-mode
  % setenv PDCONNECTWAITTIME maximum-wait-time-in-HiRDB-client-during-server-connection
  % setenv PDCLTPATH trace-file-storage-directory
  % setenv PDSQLTRACE SQL-trace-file-size
  % setenv PDUAPERLOG error-log-file-size
  % setenv PDERRSKIPCODE SQLCODE[,SQLCODE]...
  % setenv PDPRMTRC {YES|NO|IN|OUT|INOUT}
  % setenv PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
  % setenv PDTRCMODE {ERR|NONE}
  % setenv PDUAPREPLVL {[s][u][p][r]|a}
  % setenv PDREPPATH storage-directory-for-UAP-statistical-report-files
  % setenv PDTRCPATH storage-directory-for-dynamic-SQL-trace-files
  % setenv PDSQLTRCOPENMODE {CNCT|SQL}
  % setenv PDSQLTEXTSIZE SQL-statement-size
  % setenv PDSQLEXECTIME {YES|NO}
  % setenv PDRCTRACE reconnect-trace-file-size
  % setenv PDWRTLNPATH storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
  % setenv PDWRTLNFILSZ maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
  % setenv PDWRTLNCOMSZ total-size-of-WRITE-LINE-statement-value-expression-values
  % setenv PDUAPEXERLOGUSE {YES|NO}
  % setenv PDUAPEXERLOGPRMSZ maximum-data-length-of-parameter-information
  % setenv PDVWOPTMODE {0|1|2}
  % setenv PDTAAPINFPATH access-path-information-file-output-directory-name
  % setenv PDTAAPINFMODE {0|1}
  % setenv PDTAAPINFSIZE access-path-information-file-size
  % setenv PDSTJTRNOUT {YES|NO}
  % setenv PDLOCKLIMIT maximum-locked-resource-request-count-per-user
  % setenv PDDLKPRIO {96|64|32}
  % setenv PDLOCKSKIP {YES|NO}
  % setenv PDFORUPDATEEXLOCK {YES|NO}
  % setenv PDISLLVL data-guarantee-level
  % setenv PDSQLOPTLVL SQL-optimization-option[,SQL-optimization-option]...
  % setenv PDADDITIONALOPTLVL SQL-extension-optimizing-option
                              [,SQL-extension-optimizing-option]...
  % setenv PDHASHTBLSIZE hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
  % setenv PDDFLNVAL {USE|NOUSE}
  % setenv PDAGGR group-count-resulting-from-grouping
  % setenv PDCMMTBFDDL {YES|NO}
  % setenv PDPRPCRCLS {YES|NO}
  % setenv PDAUTOCONNECT {ON|OFF}
  % setenv PDDDLDEAPRP {YES|NO}
  % setenv PDCURSORLVL {0|1|2}
  % setenv PDDELRSVWDFILE SQL-reserved-word-deletion-file-name
  % setenv PDHJHASHINGMODE {TYPE1|TYPE2}
  % setenv PDBLKF block-transfer-row-count
  % setenv PDBINARYBLKF {YES|NO}
  % setenv PDBLKBUFFSIZE communication-buffer-size
  % setenv PDNODELAYACK {YES|NO}
  % setenv PDDBACCS generation-number-of-RDAREA-to-be-accessed
  % setenv PDDBORGUAP {YES|NO}
  % setenv PDSPACELVL {0|1|3}
  % setenv PDCLTRDNODE XDM/RD-E2-database-identifier
  % setenv PDTP1SERVICE {YES|NO}
  % setenv PDCNSTRNTNAME {LEADING|TRAILING}
  % setenv PDBESCONHOLD {YES|NO}
  % setenv PDBESCONHTI BES-connection-holding-period
  % setenv PDRDABLKF batch-retrieval-row-count
  % setenv PDODBSTATCAHE {0|1}
  % setenv PDODBESCAPE {0|1}
  % setenv PDGDATAOPT {YES|NO}
  % setenv PDODBLOCATOR {YES|NO}
  % setenv PDODBSPLITSIZE partition-acquisition-size
  % setenv PDODBCWRNSKIP {YES|NO}
  % setenv PDJETCOMPATIBLE {YES|NO}
  % setenv PDPLGIXMK {YES|NO}
  % setenv PDPLGPFSZ initial-size-of-delayed-batch-creation-index-information-file
  % setenv PDPLGPFSZEXP extension-value-of-delayed-batch-creation-index-information-file

Notes on the UNIX environment

• The environment variables are required for preprocessing. For details about preprocessing, see 8.2 Preprocessing.
• If different directories are used for storing shared libraries for the client during UAP creation and UAP execution, specify the -W1,+s option in the cc or ccbl command. During UAP execution, specify the name of the directory containing the shared libraries in the SHLIB_PATH environment variable. For details about the cc and ccbl commands, see 8.3 Compiling and linking.
• When you use the Type4 JDBC driver, client environment definitions set using this method are not valid.
• Client environment definitions that begin with PDJDB are not valid when they are set using this method.

In the Windows environment, the directory is set automatically to the PATH environment variable. However, the directory may not be set automatically if the path name is too long or if you do not have write privileges for PATH. You should therefore check whether the directory has been set to PATH. If the directory has not been set, you must add the following directory to PATH. xxxx indicates the directory name in which the HiRDB client is installed.

xxxx\UTL

Set the environment variables as system environment variables or user environment variables, or store them in the HiRDB.INI file in the Windows directory. If you are using a function in the UAP to set the environment variables, use the SetEnvironmentVariable function. Do not use the putenv function.

• Retrieval sequence for client environment definitions
  If the client environment definitions are set at several locations, each client environment definition is retrieved in the sequence below. If a client environment definition has no specified value, the default value is applied.
  
  1. Environment variables group^*
  2. User environment variables
  3. HIRDB.ini

  * When the multi-connection facility is used, use ALLOCATE CONNECTION HANDLE to specify the group name or file name. If a UAP under OLTP is used as the client, specify the group name or file name in an open character string. For details about open character strings, see the HiRDB Version 8 Installation and Design Guide.

A specification example of the HiRDB.INI file is shown below.

 
  [HIRDB]
  PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
  PDNAMEPORT=HiRDB-server-port-number
  PDFESHOST=front-end-server-host-name
            [:port-number-of-unit-containing-front-end-server]
              [,secondary-system-front-end-server-host-name
               [:port-number-of-unit-containing-secondary-system-front-end-server]]
  PDSERVICEGRP=server-name
  PDSRVTYPE={WS|PC}
  PDSERVICEPORT=high-speed-connection-port-number
              [,secondary-system-high-speed-connection-port-number]
  PDFESGRP=FES-group[,switchover-FES-group[,switchover-FES-group]...]
  PDCLTRCVPORT=client-receive-port-number
  PDCLTRCVADDR={client-IP-address|client-host-name}
  PDXATRCFILEMODE={LUMP|SEPARATE}
  PDUSER=[authorization-identifier/password]
  PDCLTAPNAME=identification-name-of-UAP-to-be-executed
  PDCLTLANG={SJIS|CHINESE|UJIS|C}
  PDLANG={UTF-8|SJIS|CHINESE|ANY}
  PDDBLOG={ALL|NO}
  PDEXWARN={YES|NO}
  PDSUBSTRLEN={3|4|5|6}
  PDCLTCNVMODE={AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|
   UTF8_TXT|UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|
   UCS2_UTF8}
  PDCLTGAIJIDLL=user-defined-external-character-conversion-DLL-file-name
  PDCLTGAIJIFUNC=user-defined-external-character-conversion-function-name
  PDCLTGRP=client-group-name
  PDTCPCONOPT={0|1}
  PDAUTORECONNECT={YES|NO}
  PDRCCOUNT=CONNECT-retry-count-with-automatic-reconnect-facility
  PDRCINTERVAL=CONNECT-retry-interval-with-automatic-reconnect-facility
  PDUAPENVFILE=UAP-environment-definition-file-name
  PDDBBUFLRU={YES|NO}
  PDHATRNQUEUING=NO
  PDASTHOST=HiRDB-Control-Manager-Agent-host-name
       [,secondary-system-HiRDB-Control-Manager-Agent-host-name]
   PDASTPORT=HiRDB-Control-Manager-Agent-port-number
   PDSYSTEMID=HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control Manager-Agent
  PDASTUSER=OS-user-name/password
  PDCMDWAITTIME=maximum-client-wait-time-during-command-execution
  PDCMDTRACE=command-trace-file-size
  PDIPC={MEMORY|DEFAULT}
  PDSENDMEMSIZE=data-send-memory-size-in-client
  PDRECVMEMSIZE=data-receive-memory-size-in-client
  PDCWAITTIME=maximum-client-wait-time
  PDSWAITTIME=maximum-server-wait-time-during-transaction-processing
  PDSWATCHTIME=maximum-server-wait-time-outside-transaction-processing
  PDCWAITTIMEWRNPNT=output-timing-for-SQL-runtime-warning
  PDKALVL={0|1|2}
  PDKATIME=packet-send-interval
  PDTIMEDOUTRETRY=retry-count
  PDNBLOCKWAITTIME=connection-establishment-monitoring-time-in-nonblock-mode
  PDCONNECTWAITTIME=maximum-wait-time-in-HiRDB-client-during-server-connection
  PDCLTPATH=trace-file-storage-directory
  PDSQLTRACE=SQL-trace-file-size
  PDUAPERLOG=error-log-file-size
  PDERRSKIPCODE=SQLCODE[,SQLCODE]...
  PDPRMTRC={YES|NO|IN|OUT|INOUT}
  PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
  PDTRCMODE={ERR|NONE}
  PDUAPREPLVL={[s][u][p][r]|a}
  PDREPPATH=storage-directory-for-UAP-statistical-report-files
  PDTRCPATH=storage-directory-for-dynamic-SQL-trace-files
  PDSQLTRCOPENMODE={CNCT|SQL}
  PDSQLTEXTSIZE=SQL-statement-size
  PDSQLEXECTIME={YES|NO}
  PDRCTRACE=reconnect-trace-file-size
  PDWRTLNPATH=storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
  PDWRTLNFILSZ=maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
  PDWRTLNCOMSZ=total-size-of-WRITE-LINE-statement-value-expression-values
  PDUAPEXERLOGUSE={YES|NO}
  PDUAPEXERLOGPRMSZ=maximum-data-length-of-parameter-information
  PDVWOPTMODE={0|1|2}
  PDTAAPINFPATH=access-path-information-file-output-directory-name
  PDTAAPINFMODE={0|1}
  PDTAAPINFSIZE=access-path-information-file-size
  PDSTJTRNOUT={YES|NO}
  PDLOCKLIMIT=maximum-locked-resource-request-count-per-user
  PDDLKPRIO={96|64|32}
  PDFORUPDATEEXLOCK={YES|NO}
  PDLOCKSKIP={YES|NO}
  PDISLLVL=data-guarantee-level
  PDSQLOPTLVL=SQL-optimization-option[,SQL-optimization-option]...
  PDADDITIONALOPTLVL=SQL-extension-optimizing-option
                      [,SQL-extension-optimizing-option]...
  PDHASHTBLSIZE=hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
  PDDFLNVAL={USE|NOUSE}
  PDAGGR=group-count-resulting-from-grouping
  PDCMMTBFDDL={YES|NO}
  PDPRPCRCLS={YES|NO}
  PDAUTOCONNECT={ON|OFF}
  PDDDLDEAPRP={YES|NO}
  PDCURSORLVL={0|1|2}
  PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name
  PDHJHASHINGMODE={TYPE1|TYPE2}
  PDBLKF=block-transfer-row-count
  PDBINARYBLKF={YES|NO}
  PDBLKBUFFSIZE=communication-buffer-size
  PDNODELAYACK={YES|NO}
  PDDBACCS=generation-number-of-RDAREA-to-be-accessed
  PDDBORGUAP={YES|NO}
  PDSPACELVL={0|1|3}
  PDCLTRDNODE=XDM/RD-E2-database-identifier
  PDTP1SERVICE={YES|NO}
  PDRDCLTCODE={SJIS|UTF-8}
  PDCNSTRNTNAME={LEADING|TRAILING}
  PDBESCONHOLD={YES|NO}
  PDBESCONHTI=BES-connection-holding-period
  PDODBSTATCAHE={0|1}
  PDODBESCAPE={0|1}
  PDGDATAOPT={YES|NO}
  PDODBLOCATOR={YES|NO}
  PDODBSPLITSIZE=partition-acquisition-size
  PDODBCWRNSKIP={YES|NO}
  PDJETCOMPATIBLE={YES|NO}
  PDPLGIXMK={YES|NO}
  PDPLGPFSZ=initial-size-of-delayed-batch-creation-index-information-file
  PDPLGPFSZEXP=extension-value-of-delayed-batch-creation-index-information-file

Notes on the Windows environment

• The environment variables are required for preprocessing. For details about how to preprocess, see 8.2 Preprocessing.
• When you use the Type4 JDBC driver, client environment definitions set using this method are not valid.
• Client environment definitions that begin with PDJDB are not valid when they are set using this method.