SET SESSION UDFSEARCHPATH SQL Statement | Teradata Vantage - 17.10 - 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.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
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.

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.