Comment on page
MSCEWI1036
Data type converted to another data type.
Low
This warning appears when a data type is changed into another one.
CREATE TABLE SNOWCONVERT.DATATYPES_CONVERSION
(
INTERVAL_YEAR_TYPE INTERVAL YEAR(2),
INTERVAL_MONTH_TYPE INTERVAL MONTH(2),
XMLTYPE_SYSXMLTYPE_TYPE SYS.XMLTYPE
);
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 ***/);
- This warning is only to indicate the conversion of a specific data type to another functional equivalent data type.