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.

When a connection is made using the Open Client or JDBC interfaces, some option settings are explicitly set for the current connection to be compatible with Adaptive Server Enterprise.

For information on how the settings are made, see Reference: Building Blocks, Tables, and Procedures.

Transact-SQL Options Set Explicitly for ASE Compatibility

Option

ASE-compatible setting

ALLOW_NULLS_BY_DEFAULT

OFF

ANSINULL

OFF

CHAINED

OFF

CONTINUE_AFTER_RAISERROR

ON

DATE_FORMAT

YYYY-MM-DD

DATE_ORDER

MDY

ESCAPE_CHARACTER

OFF

ISOLATION_LEVEL

1

ON_TSQL_ERROR

CONDITIONAL

QUOTED_IDENTIFIER

OFF

TIME_FORMAT

HH:NN:SS.SSS

TIMESTAMP_FORMAT

YYYY-MM-DD HH:NN:SS.SSS

TSQL_VARIABLES

OFF