Transact-SQL and ANSI/ISO SQL Standard Compatibility options

There are several compatibility options that allow you to make SQL Anywhere behavior compatible with Adaptive Server Enterprise, or to support both old behavior and allow ANSI/ISO SQL Standard behavior.

Where SAP Adaptive Server Enterprise has a comparable option, these entries are flagged ASE.

The default setting for some of these options differs from the Adaptive Server Enterprise default setting. To ensure compatibility across your SQL Anywhere and Adaptive Server Enterprise databases, explicitly set each of the compatibility options.

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 SQL Anywhere SET OPTION statement.

• allow_nulls_by_default option
• ansi_blanks option
• ansi_close_cursors_on_rollback option
• ansi_permissions option (ASE)
• ansi_substring option
• ansi_update_constraints option
• ansinull option (ASE)
• chained option (ASE)
• close_on_endtrans option (ASE)
• continue_after_raiserror option
• conversion_error option
• date_format option (ASE)
• date_order option
• divide_by_zero_error option
• escape_character option (reserved for system use)
• fire_triggers option
• first_day_of_week option (ASE)
• isolation_level option (ASE)
• nearest_century option
• non_keywords option
• on_tsql_error option
• quoted_identifier option (ASE)
• reserved_keywords option
• string_rtruncation option (ASE)
• time_format option
• timestamp_format option
• tsql_outer_joins option
• tsql_variables option
• SET statement [T-SQL]