Links
Comment on page

MSCEWI1036

Data type converted to another data type.

Severity

Low

Description

This warning appears when a data type is changed into another one.

Example Code

Source Code:

CREATE TABLE SNOWCONVERT.DATATYPES_CONVERSION
(
INTERVAL_YEAR_TYPE INTERVAL YEAR(2),
INTERVAL_MONTH_TYPE INTERVAL MONTH(2),
XMLTYPE_SYSXMLTYPE_TYPE SYS.XMLTYPE
);

Converted Code:

CREATE OR REPLACE TABLE SNOWCONVERT.DATATYPES_CONVERSION (
INTERVAL_YEAR_TYPE VARCHAR(21) /*** MSC-WARNING - MSCEWI1036 - INTERVAL DATA TYPE "YEAR(2)" CONVERTED TO VARCHAR ***/,
INTERVAL_MONTH_TYPE VARCHAR(21) /*** MSC-WARNING - MSCEWI1036 - INTERVAL DATA TYPE "MONTH(2)" CONVERTED TO VARCHAR ***/,
XMLTYPE_SYSXMLTYPE_TYPE VARIANT /*** MSC-WARNING - MSCEWI1036 - XMLTYPE DATA TYPE "SYS.XMLTYPE" CONVERTED TO VARIANT ***/);

Recommendations

  • This warning is only to indicate the conversion of a specific data type to another functional equivalent data type.
  • If you need more support, you can email us at [email protected]