PGS Connector Options

Options

• checks
• connection pooling
• connections
• entity names
• hold statements
• identifiers
• lock timeout
• keysetcursor
• lock isolation
• logon timeout
• map fixed length to variable
• maxlockwait
• open statements
• procedures
• ri
• segmented fields
• smp
• step size
• stmtcache

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 and ri=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