Embedded Services System Functions are a type of UDF, located in the TD_SYSFNLIB database. To invoke these system functions, 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 runs the customer-developed UDF instead of the embedded services system function.
To make sure 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. See SET SESSION for more information.
- Remove any customer-developed UDFs with the same name from the normal UDF search path.