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/2003 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].
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, you should explicitly set each of the compatibility options listed in this section.
When a connection is made using the Open Client or JDBC interfaces, some option settings are explicitly set for the current connection to be compatible with Adaptive Server Enterprise. These options are listed in the following table.
Option | Setting |
---|---|
allow_nulls_by_default | Off |
ansi_blanks | Off |
ansi_substring | On |
ansinull | On |
chained | Off |
continue_after_raiserror | On |
escape_character | Off |
on_tsql_error | Continue for jConnect connections |
time_format | HH:NN:SS.SSS |
timestamp_format | YYYY-MM-DD HH:NN:SS.SSS |
tsql_outer_joins | Off |
tsql_variables | On |
The following table lists the compatibility options, their allowed values, and their default settings.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |