Transact-SQL compatibility options allow Sybase IQ behavior to be compatible with Adaptive Server Enterprise, or to both support old behavior and allow ISO SQL92 behavior.
For further compatibility with Adaptive Server Enterprise, you can set some of these options for the duration of the current connection using the Transact-SQL SET statement instead of the Sybase IQ SET OPTION statement.
Option |
Allowed values |
Default setting |
|---|---|---|
ALLOW_NULLS_BY_DEFAULT |
ON, OFF |
ON |
ANSI_BLANKS* |
ON, OFF |
OFF |
ANSI_CLOSE_CURSORS_ON_ROLLBACK |
ON |
ON |
ANSI_INTEGER_OVERFLOW* |
||
ANSI_PERMISSIONS |
ON, OFF |
ON |
ANSINULL |
ON, OFF |
ON |
ANSI_SUBSTRING |
ON, OFF |
ON |
ANSI_UPDATE_CONSTRAINTS |
OFF, CURSORS, STRICT |
CURSORS |
ASE_BINARY_DISPLAY |
ON, OFF |
OFF |
ASE_FUNCTION_BEHAVIOR |
ON, OFF |
OFF |
CHAINED |
ON, OFF |
ON |
CLOSE_ON_ENDTRANS |
ON |
ON |
CONTINUE_AFTER_RAISERROR |
ON, OFF |
ON |
CONVERSION_ERROR |
ON, OFF |
ON |
DIVIDE_BY_ZERO_ERROR |
ON, OFF |
ON |
ESCAPE_CHARACTER* |
Reserved |
Reserved |
FIRE_TRIGGERS* |
ON, OFF |
ON |
NEAREST_CENTURY |
0 – 100 |
50 |
NON_KEYWORDS |
Comma-separated keywords list |
No keywords turned off |
ON_TSQL_ERROR |
STOP, CONTINUE, CONDITIONAL |
CONDITIONAL |
QUERY_PLAN_ON_OPEN* |
||
QUOTED_IDENTIFIER |
ON, OFF |
ON |
RI_TRIGGER_TIME* |
||
SQL_FLAGGER_ERROR_LEVEL |
E, I, F, W, OFF, SQL:1992/Entry, SQL:1992/Intermediate, SQL:1992/Full, SQL:1999/Core, SQL:1999/Package, SQL:2003/Core, SQL:2003/Package |
OFF |
SQL_FLAGGER_WARNING_LEVEL |
E, I, F, W, OFF, SQL:1992/Entry, SQL:1992/Intermediate, SQL:1992/Full, SQL:1999/Core, SQL:1999/Package, SQL:2003/Core, SQL:2003/Package |
OFF |
STRING_RTRUNCATION |
ON, OFF |
ON |
TEXTSIZE* |
||
TSQL_HEX_CONSTANT* |
||
TSQL_VARIABLES |
ON, OFF |
OFF |
An asterisk (*) next to the option name indicates an option currently not supported by Sybase IQ.