SET SESSION UDFSEARCHPATH SQL Statement | Teradata Vantage - 17.00 - SET SESSION UDFSEARCHPATH - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Allows you to specify a custom UDF search path. When you execute a UDF, Vantage searches this path first, before looking in the default Vantage search path for the UDF.

If you have created your own UDF that has the same name as a Vantage system UDF, you can use this statement to ensure Vantage executes your UDF, rather than the Vantage system UDF.

For more information about creating UDFs, see Teradata Vantage™ - SQL External Routine Programming , B035-1147 .

Privileges

You must have access to any database you specify as part of the UDF search path.