16.20 - Invoking Embedded Services System Functions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

You can invoke an embedded services function using the function name alone. For example, CEILING (arg).

You can also qualify the function name by adding the TD_SYSFNLIB database name. For example, you can invoke the CEILING function using the fully qualified syntax, TD_SYSFNLIB.CEILING(arg).

If you try to invoke an embedded services function using the function name alone, but you also have a customer-developed UDF with the same name in the current database or in the SYSLIB database, Teradata Database will execute the customer-developed UDF instead of the embedded services function.
Therefore, to ensure that you are invoking the embedded services function, do one of the following:
  • Remove any customer-developed UDFs with the same name from the normal UDF search path; that is, from the current database and from the SYSLIB database. For detailed information, see “UDF Locations” in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .
  • Use the fully qualified syntax to invoke the embedded services function.