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

Teradata Vantageā„¢ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1098-171K
Language
English (United States)

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.