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
Medium
A function was not recognized by the conversion tool
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
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();
- 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.