Setting options for Transact-SQL compatibility

You set SQL Anywhere database options using the SET OPTION statement. Several database option settings are relevant to Transact-SQL behavior.

 Set the allow_nulls_by_default option
 Set the quoted_identifier option
 Set the string_rtruncation option