Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Option classification » Compatibility options

 

Transact-SQL and SQL/2008 compatibility options

The following table lists the compatibility options, their allowed values, and their default settings.

Option Values Default
allow_nulls_by_default option On, Off On
ansi_blanks option On, Off Off
ansi_close_cursors_on_rollback option On, Off Off
ansi_permissions option On, Off On
ansi_update_constraints option Off, Cursors, Strict Cursors
ansinull option On, Off On
chained option On, Off On
close_on_endtrans option On, Off On
continue_after_raiserror option On, Off On
conversion_error option On, Off On
date_format option String YYYY-MM-DD
date_order option MDY, YMD, DMY YMD
divide_by_zero_error option On, Off On
escape_character option Reserved Reserved
fire_triggers option On, Off On
isolation_level option 0, 1, 2, 3 0
nearest_century option Integer (between 0 and 100 inclusive) 50
non_keywords option String (Comma-separated keywords list) Empty string (No keywords turned off)
on_tsql_error option Stop, Conditional, Continue Conditional
quoted_identifier option On, Off On
reserved_keywords option String (Comma-separated keywords list) Empty string (No keywords turned off)
sql_flagger_error_level option Off, SQL:1992/Entry, SQL:1992/Intermediate, SQL:1992/Full, SQL:1999/Core, SQL:1999/Package, SQL:2003/Core, SQL:2003/Package, UltraLite Off
sql_flagger_warning_level option Off, SQL:1992/Entry, SQL:1992/Intermediate, SQL:1992/Full, SQL:1999/Core, SQL:1999/Package, SQL:2003/Core, SQL:2003/Package, UltraLite Off
string_rtruncation option On, Off On
time_format option String HH:NN:SS.SSS
timestamp_format option String YYYY-MM-DD HH:NN:SS.SSS
tsql_outer_joins option On, Off Off
tsql_variables option On, Off Off