Server options refer to Adaptive Server option settings, which are session-level settings that affect the way Adaptive Server handles results and various aspects of a client connection. For example, when setting the ROWCOUNT option, Adaptive Server limits all result sets to the number of rows specified with the option.
To set such options within Adaptive Server, use a language command, an explicit Adaptive Server Enterprise system procedure—sp_dboption, or an Open Client API request—ct_options.
See Chapter 1, “System Procedures” in the Adaptive
Server Enterprise Reference Manual: Procedures for instructions
on using the sp_dboption system procedure. See
the Open Client Client-Library/C Reference Manual for instructions
on using ct_options.
OpenSwitch does not parse the SQL code passed between Adaptive Server and the client. Therefore, it is not aware of options set with either language commands or the SET command. Such option settings are lost when the connection is switched from one server to another.
OpenSwitch is aware of options set using Open Client API calls, and internally tracks the options that are currently set on the connection. These settings are restored correctly on any new servers to which the connection is switched.
Sybase strongly recommends that client applications
use an Adaptive Server Enterprise system procedure or an Open Client
API call rather than language commands to set server options.
