Transact-SQL Compatibility Options

Transact-SQL compatibility options allow SAP Sybase IQ behavior to be compatible with Adaptive Server Enterprise, or to both support old behavior and allow ISO SQL92 behavior.

For further compatibility with Adaptive Server Enterprise, you can set some of these options for the duration of the current connection using the Transact-SQL SET statement instead of the SAP Sybase IQ SET OPTION statement.

• Transact-SQL Option Settings for Adaptive Server Enterprise Compatibility
  The default setting for some options differs from the Adaptive Server Enterprise default setting. To ensure compatible behavior, you should explicitly set the options.