The following options allow Sybase IQ behavior to be made compatible with Adaptive Server Enterprise, or to both support 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 Sybase IQ SET OPTION statement. For a listing, see the SET statement.
The default setting for some of these options differs from the Adaptive Server Enterprise default setting. To ensure compatible behavior, you should explicitly set the options.
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 Table 2-2.
For information on how the settings are made, see Chapter 9, “System Procedures”.
Option |
ASE-compatible setting |
|---|---|
ALLOW_NULLS_BY_DEFAULT |
OFF |
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 |
TIME_FORMAT |
HH:NN:SS.SSS |
TIMESTAMP_FORMAT |
YYYY-MM-DD HH:NN:SS.SSS |
TSQL_HEX_CONSTANT |
ON |
TSQL_VARIABLES |
OFF |
The following table lists the compatibility options, their allowed values, and their default settings.
See the sections “General database options” and “DBISQL options” for lists of the other classes of options.
OPTION |
VALUES |
DEFAULT |
|---|---|---|
ALLOW_NULLS_BY_DEFAULT |
ON, OFF |
ON |
ANSI_BLANKS* |
||
ANSI_CLOSE_CURSORS_ON_ ROLLBACK |
ON |
ON |
ANSI_INTEGER_OVERFLOW* |
||
ANSI_PERMISSIONS |
ON, OFF |
ON |
ANSINULL |
ON, OFF |
ON |
ANSI_UPDATE_CONSTRAINTS |
OFF, CURSORS, STRICT |
CURSORS |
ASE_BINARY_DISPLAY |
ON, OFF |
ON |
AUTOMATIC_TIMESTAMP |
OFF |
OFF |
CHAINED |
ON, OFF |
ON |
CLOSE_ON_ENDTRANS |
ON |
ON |
CONTINUE_AFTER_RAISEERROR |
ON, OFF |
ON |
CONVERSION_ERROR |
ON, OFF |
ON |
DIVIDE_BY_ZERO_ERROR |
ON, OFF |
ON |
ESCAPE_CHARACTER* |
ON |
ON |
FIRE_TRIGGERS* |
||
FLOAT_AS_DOUBLE |
ON, OFF |
OFF |
NEAREST_CENTURY |
0 to 100 |
50 |
NON_KEYWORDS |
Comma separated keywords list |
No keywords turned off |
ON_TSQL_ERROR |
STOP, CONTINUE, CONDITIONAL |
CONDITIONAL |
PERCENT_AS_COMMENT |
ON, OFF |
ON |
QUERY_PLAN_ON_OPEN* |
||
QUOTED_IDENTIFIER |
ON, OFF |
ON |
RI_TRIGGER_TIME* |
||
SQL_FLAGGER_ERROR_LEVEL |
E, I, F, W |
W |
SQL_FLAGGER_WARNING_ LEVEL |
E, I, F, W |
W |
STRING_RTRUNCATION |
ON, OFF |
OFF |
TEXTSIZE* |
||
TSQL_HEX_CONSTANT |
ON, OFF |
OFF |
TSQL_VARIABLES |
ON, OFF |
OFF |
An asterisk (*) next to the option name in
the above table indicates an option that is currently not supported
by Sybase IQ.
