ASA Database Administration Guide
Database Options
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 [T-SQL].
Default settings
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.
Options for Open Client and JDBC connection compatibility with Adaptive Server Enterprise
|
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_HEX_CONSTANT
|
ON
|
|
TSQL_VARIABLES
|
ON
|
|
TIME_FORMAT
|
HH:NN:SS.SSS
|
|
TIMESTAMP_FORMAT
|
YYYY-MM-DD HH:NN:SS.SSS
|
Transact-SQL and SQL/92 compatibility options
The following table lists the compatibility options, their allowed values, and their default settings.
|
OPTION
|
VALUES
|
DEFAULT
|
|---|
|
ALLOW_NULLS_BY_DEFAULT option [compatibility]
|
ON, OFF
|
ON
|
|
ANSI_BLANKS option [compatibility]
|
ON, OFF
|
OFF
|
|
ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility]
|
ON, OFF
|
OFF
|
|
ANSI_INTEGER_OVERFLOW option [compatibility]
|
ON, OFF
|
OFF
|
|
ANSI_PERMISSIONS option [compatibility]
|
ON, OFF
|
ON
|
|
ANSI_UPDATE_CONSTRAINTS option [compatibility]
|
OFF, CURSORS, STRICT
|
CURSORS
|
|
ANSINULL option [compatibility]
|
ON, OFF
|
ON
|
|
AUTOMATIC_TIMESTAMP option [compatibility]
|
ON, OFF
|
OFF
|
|
CHAINED option [compatibility]
|
ON, OFF
|
ON
|
|
CLOSE_ON_ENDTRANS option [compatibility]
|
ON, OFF
|
ON
|
|
CONTINUE_AFTER_RAISERROR option [compatibility]
|
ON,OFF
|
ON
|
|
CONVERSION_ERROR option [compatibility]
|
ON,OFF
|
ON
|
|
DIVIDE_BY_ZERO_ERROR option [compatibility]
|
ON, OFF
|
ON
|
|
ESCAPE_CHARACTER option [compatibility]
|
System use
|
OFF
|
|
FIRE_TRIGGERS option [compatibility]
|
ON, OFF
|
ON
|
|
FLOAT_AS_DOUBLE option [compatibility]
|
ON, OFF
|
OFF
|
|
NEAREST_CENTURY option [compatibility]
|
Integer
|
50
|
|
NON_KEYWORDS option [compatibility]
|
comma-separated keywords list
|
No keywords turned off
|
|
ON_TSQL_ERROR option [compatibility]
|
STOP, CONDITIONAL, CONTINUE
|
CONDITIONAL
|
|
PERCENT_AS_COMMENT option [compatibility]
|
ON, OFF
|
ON
|
|
QUERY_PLAN_ON_OPEN option [compatibility]
|
ON, OFF
|
OFF
|
|
QUOTED_IDENTIFIER option [compatibility]
|
ON, OFF
|
ON
|
|
RI_TRIGGER_TIME option [compatibility]
|
BEFORE, AFTER
|
AFTER
|
|
SQL_FLAGGER_ERROR_LEVEL option [compatibility]
|
E, I, F, W
|
W
|
|
SQL_FLAGGER_WARNING_LEVEL option [compatibility]
|
E, I, F, W
|
W
|
|
STRING_RTRUNCATION option [compatibility]
|
ON, OFF
|
OFF
|
|
TSQL_HEX_CONSTANT option [compatibility]
|
ON, OFF
|
ON
|
|
TSQL_VARIABLES option [compatibility]
|
ON, OFF
|
OFF
|