MSCEWI4016

Translation for ODBC Scalar function pending

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

Severity

Medium

Description

This EWI is added when SnowConvert finds a ODBC Scalar function inside the input code. User defined functions are not supported in ODBC Scalar Function.

Code Example

Input Code:

SELECT {fn CURRENT_DATE()};

Output Code:

SELECT PUBLIC.ODBC_UDF('{fn PUBLIC.CURRENT_DATE_UDF(\'CURRENT_DATE()\') /*** MSC-ERROR - MSCEWI1031 - CURRENT_DATE FUNCTION NOT SUPPORTED ***/}') /*** MSC-ERROR - MSCEWI4016 - USER DEFINED FUNCTIONS ARE NOT SUPPORTED IN ODBC SCALAR FUNCTION. ***/;

Recommendations

• No additional user actions are required, it is just informative.

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