Sybase Adaptive Server Anywhere - Page 182

Transact-SQL and SQL/92 compatibility options
164
The following table lists the compatibility options, their allowed values, and
their default settings.
OPTION VALUES DEFAULT
"ALLOW_NULLS_BY_DEFAULT
option" on page 169
ON, OFF ON
"ANSI_BLANKS option" on page 169 ON, OFF OFF
"ANSI_CLOSE_CURSORS_ON_RO
LLBACK option" on page 170
ON, OFF OFF
"ANSI_INTEGER_OVERFLOW
option" on page 170
ON, OFF OFF
"ANSI_UPDATE_CONSTRAINTS
option" on page 171
OFF,
CURSORS,
STRICT
CURSORS
"ANSINULL option" on page 172 ON, OFF ON
"ANSI_PERMISSIONS option" on
page 170
ON, OFF ON
"AUTOMATIC_TIMESTAMP option"
on page 173
ON, OFF OFF
"CHAINED option" on page 175 ON, OFF ON
"CLOSE_ON_ENDTRANS option" on
page 177
ON, OFF ON
"CONTINUE_AFTER_RAISERROR
option" on page 179
ON,OFF ON
"CONVERSION_ERROR option" on
page 180
ON,OFF ON
"DIVIDE_BY_ZERO_ERROR option"
on page 186
ON, OFF ON
"ESCAPE_CHARACTER option" on
page 186
System use OFF
"FIRE_TRIGGERS option" on
page 187
ON, OFF ON
"FLOAT_AS_DOUBLE option" on
page 187
ON, OFF OFF
"NEAREST_CENTURY option" on
page 199
integer 50
"NON_KEYWORDS option" on
page 199
comma-
separated
keywords list
No keywords turned off
List of options