Icon for Previous Page button Icon for Next Page button

Compatibility options

The following options allow you to make SQL Anywhere behavior compatible with Adaptive Server Enterprise, or to support both old behavior and allow ISO SQL/2008 behavior.

For further compatibility with Adaptive Server Enterprise, some of these options can be set for the duration of the current connection using the Transact-SQL SET statement instead of the SQL Anywhere SET OPTION statement. See SET statement [T-SQL].

 Default settings

Options for Sybase Open Client and JDBC connection compatibility with Adaptive Server Enterprise
Transact-SQL and SQL/2008 compatibility options