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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
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 .

ANSI Compliance

SET SESSION UDFSEARCHPATH is ANSI-2011 SQL-compliant with extensions.

Required Privileges

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