Reference Manual
CHAPTER 5. Database 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.
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.
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 |
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 |
OPTION |
VALUES |
DEFAULT |
|---|---|---|
ON, OFF |
ON |
|
ON, OFF |
OFF |
|
ON, OFF |
OFF |
|
ON, OFF |
ON |
|
ON, OFF |
ON |
|
ON, OFF |
ON |
|
ON, OFF |
OFF |
|
ON, OFF |
ON |
|
ON, OFF |
ON |
|
ON,OFF |
OFF |
|
ON,OFF |
ON |
|
ON, OFF |
OFF |
|
ON, OFF |
ON |
|
ON, OFF |
OFF |
|
integer |
50 |
|
comma-separated keywords list |
No keywords turned off |
|
ON, OFF |
ON |
|
ON, OFF |
OFF |
|
ON, OFF |
ON |
|
BEFORE, AFTER |
AFTER |
|
E, I, F, W |
W |
|
E, I, F, W |
W |
|
ON, OFF |
OFF |
|
integer |
32765 |
|
ON, OFF |
OFF |
|
ON, OFF |
OFF |