If the same operand is defined in different definitions, HiRDB determines the value to be used on the basis of the priority order of the definitions, as shown below:
A standard value can be specified in a definition that has a lower priority, and then that value can be changed by specifying a different value in a definition that has a higher priority.
The values of the HiRDB system definition operands shown in Table 1-3 can be modified for a client in its client environment definition.
Table 1-3 Operands with specification values that can be modified in client environment definitions (HiRDB/Single Server)
HiRDB system definition operand | Client environment definition operand | Operand contents |
---|---|---|
pd_additional_optimize_level | PDADDITIONALOPTLVL | Specifies the SQL extension optimizing option. |
pd_cwaittime_wrn_pnt | PDCWAITTIMEWRNPNT | Specifies the condition for outputting the SQL runtime warning information of the SQL runtime warning output facility as a percentage of the client's maximum wait time (value specified by the PDCWAITTIME operand in the client environment definition). |
pd_delete_reserved_word_file | PDDELRSVWDFILE | Specifies the name of the SQL reserved word deletion file when using the SQL reserved word deletion facility. |
pd_hash_table_size | PDHASHTBLSIZE | Specifies the hash table size when hash execution of a hash join or a subquery is used as the SQL extension optimizing option. |
pd_hashjoin_hashing_mode | PDHJHASHINGMODE | Specifies the hashing method when hash join, subquery hash execution is specified as the SQL extension optimizing option. |
pd_optimize_level | PDSQLOPTLVL | Specifies the SQL optimization option. |
pd_space_level | PDSPACELVL | Specifies a space conversion level. |
pd_uap_exerror_log_param_size | PDUAPEXERLOGPRMSZ | Specifies the maximum data size for the parameter information to be output to the error log file or SQL error report file. |
pd_uap_exerror_log_use | PDUAPEXERLOGUSE | Specifies whether to use the facility for output of extended SQL error information. |
pd_watch_pc_client_time | PDSWATCHTIME | Specifies the amount of time to wait for a request from a Windows-compatible HiRDB client. |
To change the value for a client, specify the applicable operand in the client's environment definition. For details about client environment definition, see the HiRDB Version 8 UAP Development Guide.