Invoking Embedded Services System Functions - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantage™

Embedded Services System Functions are a type of UDF. They are located in the TD_SYSFNLIB database. To invoke these system functions, you should use the fully qualified syntax, for example, TD_SYSFNLIB.CEILING (arg).

Optionally, you can omit the database name, and use the function name by itself. For example, CEILING (arg). However, if you do not qualify the function name, and there is also a customer-developed UDF with the same name in the current database or in the SYSLIB database, Vantage follows the normal search path precedence for UDFs, and executes the customer-developed UDF instead of the embedded services system function. For more information on UDF search path precedence, see "UDF Locations" in Teradata Vantage™ - SQL External Routine Programming, B035-1147.

To ensure you invoke the embedded services function, do one of the following:
  • Use the fully qualified function name, including the containing database: prepend TD_SYSFNLIB. when you invoke embedded services system functions.
  • Use the SET SESSION UDFSEARCHPATH statement to specify a UDF search path precedence that explicitly searches the TD_SYSFNLIB database before other locations. For more information on SET SESSION, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
  • Remove any customer-developed UDFs with the same name from the normal UDF search path.