MSCEWI1031
Function not supported.
Medium
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.
SELECT
ISNULL(mt.[COL2 COL3 COL4],'')
FROM TABLE1;
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;
- Please go to the Teradata functions section and the Oracle functions section to check the current transformation of the specific function you are trying to convert.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 1yr ago