UDF Search Path | Advanced SQL Engine 17.00 | Teradata Vantage - 17.00 - UDF Search Path - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Summary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
September 2020
category
Release Notes
featnum
B035-1098-170K

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 .