Invoking Embedded Services System Functions

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.