Adaptive Server permits clients to determine how to handle query processing. It provides a variety of configurable options that govern aspects of query processing behavior. For more information on Adaptive Server query-processing options, see the set command in the Adaptive Server Enterprise Reference Manual.
An Open Server application can respond to client requests about query processing options.
A client application can set, clear, and request the current value of Adaptive Server query-processing options in one of two ways:
Through a Transact-SQL language command
By issuing an option command
If an application expects a client to issue language commands to make option requests that the application needs to process, it must include code to parse such requests in its SRV_LANGUAGE event handler.
Client option commands trigger a SRV_OPTION event. An application responds to such requests from within its SRV_OPTION event handler, using the srv_options command.