MSS Connector Options
You can assign connector options by setting USYS$MSS_PARAMS in the [DRIVER_SETTINGS] section of the assignment file.
USYS$MSS_PARAMS Option {,
Option1}
Options
- checks
- connection pooling
- connections
- dbowner
- entity names
- hold statements
- identifiers
- keysetcursor
- lock granularity
- lock isolation
- lock timeout
- logon timeout
- mapping
- maxlockwait
- multiple active result sets
- nls
- open statements
- pra
- procedures
- record size
- ri
- segmented fields
- slctenhance
- sql92npw
- step size
- stmtcache
- updblobspr
- upgrade fetch procedures
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
USYS$MSS_PARAMS
are:
- All options have the form
Directive = Value. Instead of the equals sign
(
=
), a colon (:
) can be used. - The total length of the assignment should not exceed 2048 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
Example long format for two options:
USYS$MSS_PARAMS = isolation=read uncommitted, entity names=upper
Example short format for four options:
USYS$MSS_PARAMS = iso:ru, ents:upper, procs:off, mapping=2