MSCEWI3048

Function language is not supported.

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

Severity

High

Description

The function language used is not supported, only SQL language is currently supported.

Example Code:

Input Code:

CREATE FUNCTION CFEXTERNALINC (p1 INTEGER, p2 INTEGER)
RETURNS TABLE(
c1 INTEGER,
c2 INTEGER,
c3 VARCHAR(3),
udtc4 INTEGER
)
LANGUAGE C
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'CS!fnc_tbf001udt!fnc_tbf001udt.c';

Output Code:

-- ** MSC-ERROR - MSCEWI3048 - FUNCTION LANGUAGE C NOT SUPPORTED IN SNOWFLAKE **
--CREATE FUNCTION DATAWAREHOUSE.PUBLIC.CFEXTERNALINC (P1 INTEGER, P2 INTEGER)
--RETURNS TABLE(
--c1 INTEGER,
--c2 INTEGER,
--c3 VARCHAR(3),
--udtc4 INTEGER
--)
--LANGUAGE C
--NO SQL
--PARAMETER STYLE SQL
--EXTERNAL NAME 'CS!fnc_tbf001udt!fnc_tbf001udt.c'

Recommendations

• Please consider reimplementing in a supported language like SQL.

• If you need more support, you can email us at [email protected]