Feature support in compatibility mode

Once you enable compatibility mode, Adaptive Server uses the query processor for all insert, delete, update, and select queries.

The query processor uses either full or partial compatibility mode:

Generally, Adaptive Server uses full compatibility mode wherever possible. If it cannot use full compatibility mode, it switches to restricted compatibility mode.

Table 3-1 lists restricted compatibility mode support for features in Adaptive Server versions earlier than 15.0:

Table 3-1: Version 12.5 feature support in compatibility mode

12.5.4 features with limited support in compatibility mode

Supported in full compatibility mode?

Supported in restricted compatibility mode?

Queries with text and image columns

No

Yes

Referential integrity

No

Yes

Inserts that require referential integrity

No

No

Proxy tables

No

Yes

Round-robin partitions

No

No

Encryption and cipher text

No

Yes

Queries that include the rand2 function

No

Yes

Abstract plans, either explicit (with plan clause) or implicit (plan dump or plan load);

No

Yes

Extended datatypes, such as Java ADT and Java UDF

No

Yes

XML functions

No

Yes

Browse mode

No

Yes

Parallel hints

No

No

Parallel sort

No

No

Compatibility mode does not support these Adaptive Server 15.0 features:

NoteQuery plans in compatibility mode are not executed as parallel plans.