Sybase Adaptive Server Anywhere - Transact-SQL and SQL;92 Compatibility Options

Chapter 5 Database Options
163
Transact-SQL and SQL/92 compatibility options
The following options allow Adaptive Server Anywhere behavior to be made
compatible with Adaptive Server Enterprise, or to support both old behavior
and allow ISO SQL/92 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 Adaptive Server Anywhere SET
OPTION statement. For a listing, see "SET statement" on page 607.
The default setting for some of these options differs from the Adaptive
Server Enterprise default setting. For compatibility, you should explicitly set
the options to ensure compatible behavior.
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.
$ For information on how the settings are made, see "System and catalog
stored procedures" on page 963.
Option Setting
ALLOW_NULLS_BY_DEFAULT OFF
ANSI_BLANKS ON
ANSINULL OFF
CHAINED OFF
CONTINUE_AFTER_RAISERROR ON
DATE_FORMAT YYYY-MM-DD
DATE_ORDER MDY
ESCAPE_CHARACTER OFF
FLOAT_AS_DOUBLE ON
ISOLATION_LEVEL 1
ON_TSQL_ERROR CONDITIONAL
QUOTED_IDENTIFIER OFF
TSQL_VARIABLES ON
TSQL_HEX_CONSTANT ON
TIME_FORMAT HH:NN:SS.SSS
TIMESTAMP_FORMAT YYYY-MM-DD HH:NN:SS.SSS
Default settings