MSCEWI1049

Not recognized function

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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]