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 .
SET SESSION UDFSEARCHPATH is ANSI-2011 SQL-compliant with extensions.
You must have access to any database you specify as part of the UDF search path.