MSCEWI1036
Data type converted to another data type.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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]
Last updated