Links

MSCEWI1031

Function not supported.

Severity

Medium

Description

This error is used to report that a specific built-in function of Teradata, Oracle or SQLServer is not supported yet. And this function is being temporarily translated to an UDF.

Example Code

Input Code:

SELECT
ISNULL(mt.[COL2 COL3 COL4],'')
FROM TABLE1;

Output Code:

CREATE OR REPLACE FUNCTION PUBLIC.ISNULL_UDF (INPUT VARCHAR)
RETURNS STRING
LANGUAGE JAVASCRIPT
AS
$$
return INPUT.concat(' NOT SUPPORTED');
$$;
SELECT
PUBLIC.ISNULL_UDF('ISNULL(mt."COL2 COL3 COL4",\'\')') /*** MSC-ERROR - MSCEWI1031 - ISNULL FUNCTION NOT SUPPORTED ***/
FROM TABLE1;

Recommendation