PGS Connector Options
You can assign connector options by setting USYS$PGS_PARAMS in the [DRIVER_SETTINGS] section of the assignment file.
USYS$PGS_PARAMSOption {,
Option1}
Options
Description
Most connector options enable or disable features. Some options have a numeric parameter (a non negative decimal integer). Every numeric option has a default value, although the range of valid values is option-specific.
Syntax Rules
The syntax rules for setting connector options are:
- Options can be set using either a colon (
:
) or an equals sign (=
). Thus Option:
Value is the same as Option=
Value.For example:
ri:on
andri=on
. - The total length of the assignment should not exceed 80 characters. Use the short format shown in the example for multiple options.
- Each option must be specified only once
- Multiple options must be separated by commas
(
,
) - Words and numbers within each option are separated by one or more spaces or tabs
- Options are not case-dependent
Long format
USYS$PGS_PARAMS = isolation=read uncommitted, entity names=upper
Short format
USYS$PGS_PARAMS = iso:ru, ents:upper