Adaptive Server Enterprise permits clients to determine how to handle query processing. It provides a variety of configurable options that govern aspects of query processing behavior. 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 Enterprise 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.
