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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.