Enabling compatibility mode

On Adaptive Server 15.0.3 ESD #1 and later, you can enable compatibility mode at the session or server-wide level:

Setting compatibility mode at the session level takes precedence over the server level.

enable compatibility mode is a dynamic configuration parameter; you need not restart Adaptive Server for it to take effect. However, you must remove any compiled plans for stored procedures, or ad hoc queries, from the statement cache.

Notesp_configure generates warnings to indicate that enabling compatibility mode does not affect cached query plans that are already in the procedure or statement cache.

sp_configure also generates warnings if it detects configuration options that conflict with compatibility mode, such as: