Sybase Connector Options
You can assign connector options by setting USYS$SYB_PARAMS in the [DRIVER_SETTINGS] section of the assignment file.
USYS$SYB_PARAMSOption {,
Optionn}
Options
- allpages locking
- convert numeric
- charset
- datapages locking
- dbms ri
- delay textptr check
- disable lower
- disable numerics
- disable procs
- disable proc check
- dump tran
- identity insert
- keyword
- language
- lock level
- maxlockwait
- multi byte
- row level locks
- row limit
- step size
- strip spaces
- tds_packetsize
- U4 upgrade
- unicode
- widetable overflow
Description
Most connector options enable or disable a specific feature by setting the option. Some options have a numeric parameter. This parameter must be a non-negative decimal integer (every numeric option has a default value). The range of valid values is option-specific.
Every connector option can be specified using either a long format, which is readable, or a short format, which allows you to set many options in the USYS$SYB_PARAMS assignment.
Syntax Rules
The syntax rules for USYS$SYB_PARAMS are as follows:
-
The assignment can be no longer than one line in the assignment file.
-
Each option may be specified once, either in long format or in short format, not both. Options in long format may be mixed with other options in short format.
-
The order in which the options are specified is not significant.
-
Multiple options must be separated by a comma.
-
Words and numbers within each option are separated by one or more spaces or tabs.
-
Options are not case-dependent.
-
All options have the form directive = value.
-
Instead of the equal sign (=), a colon (:) can be used. For example:
USYS$SYB_PARAMS = disable numerics = on, language: french, step size: 14
TM support
For TM-enabled logon paths, the following connector options are not supported:
-
tds
packetsize
-
lock
level
-
timeout