Database Compatibility
SQL/MX 3.5 provides the following database compatibility features for easier application migration to SQL/MX:
-
DATE type2 datatype
-
NUMBER datatype
-
VARCHAR2 datatype
-
TO_DATE function
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.
CQD DC_MODE
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.