Options affect how Sybase Servers respond to commands.
An application sets options to customize a server’s query-processing behavior. For example, an application sets the CS_OPT_FIPSFLAG option to tell a server to flag any nonstandard SQL commands that it receives.
A Client-Library application sets and clears Adaptive Server query-processing options in one of two ways:
By using a Transact-SQL language command (set)
By calling ct_options
An application may use only one of these methods; otherwise, Client-Library/server communications may become confused.
The ct_options method is recommended because it allows an application to check the status of an option, which is not allowed by the Transact-SQL set command.
For more information about Adaptive Server query-processing options, see the set command in the Adaptive Server Reference Manual.
