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).
- 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.