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.