The new SET SESSION UDFSearchPath statement lets you set a custom path for Teradata Vantage to use when searching for invoked UDFs.
Benefits
- Allows you to specify where Vantage should look first for UDFs. This ensures that the UDF you want will be executed in cases where there might be more than one UDF in the system with the same name.
- The UDF search path you set is applied to all forms of UDFs, including user-defined functions, user-defined types, and embedded services system functions.
Considerations
- Best practice is to use the fully qualified UDF path and name when invoking a UDF, but if you cannot or might not, you should use the new SET SESSION UDFSearchPath statement to control the location order that Vantage uses to search for the UDF.
SQL Changes
- New SET SESSION UDFSearchPath statement
Additional Information
For more information about how Teradata Vantage searches for UDFs , see "UDF Locations" in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .