Database Compatibility

SQL/MX 3.5 provides the following database compatibility features for easier application migration to SQL/MX:

While most of these features are enabled by default, some of them must be enabled by setting the CQD DC_MODE to 1.

For a list of existing database compatible functions and expressions, see SQL/MX Functions and Expressions Compatible with Oracle.


The DC_MODE CQD is introduced to enable or disable database compatibility features. The valid values are 1 (enable) and 0 (disable). The default value is 0. Setting individual feature specific CQDs like DC_DATE overrides DC_MODE setting.