17.05 - USING Support for Scalar UDFs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

You can pass USING variables in the arguments of a scalar UDF during invocation (see Example: USING and SQL UDF Invocation) when the data types of the USING variables match those of the UDF parameters, whether natively or after being explicitly cast. If the data types do not match, the database aborts the request and returns an error.

You can avoid this problem by casting the data types of the USING variables to the data types of the UDF parameters.