Links
Comment on page

MSCEWI1049

Not recognized function
This issue has been deprecated on version 4.0.87 of SnowConvert for Teradata
This issue has been deprecated on version 3.0.70 of SnowConvert for SQL Server
This issue has been deprecated on version 3.0.71 of SnowConvert for Oracle

Severity

Medium

Description

A function was not recognized by the conversion tool

Example code

Input Code:

REPLACE FUNCTION syslib.my_external_udf() // UDF declaration
...
...
SELECT syslib.my_external_udf(); // Qualified UDF
SELECT my_external_udf(); // UDF not qualified
SELECT NEWFUNCTION('param'); // Function the SnowConvert tool does not recognize yet

Output Code:

SELECT syslib.my_external_udf();
/*** MSC-ERROR - MSCEWI1049 - my_external_udf FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
SELECT my_external_udf();
/*** MSC-ERROR - MSCEWI1049 - NEWFUNCTION FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
SELECT NEWFUNCTION();

Recommendations

  • If the function is a Built-in specific function, ask for support so that the conversion tool recognizes and translates the function to a Snowflake equivalent. If the function is a UDF verify that the function is fully qualified when being called and that the function declaration is in a file in the input code being migrated.
  • If you need more support, you can email us at [email protected]