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 |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |