Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
There are several compatibility options that allow you to make SQL Anywhere behavior compatible with Adaptive Server Enterprise, or to support both old behavior and allow ANSI/ISO SQL Standard behavior.
Where SAP Adaptive Server Enterprise has a comparable option, these entries are flagged ASE.
The default setting for some of these options differs from the Adaptive Server Enterprise default setting. To ensure compatibility across your SQL Anywhere and Adaptive Server Enterprise databases, explicitly set each of the compatibility options.
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.