SET SESSION UDFSEARCHPATH Example | Teradata Vantage - Example: SET SESSION UDFSEARCHPATH - Teradata Vantage - Analytics Database

CREATE FUNCTION functions.bitor(A INTEGER,B INTEGER,C INTEGER)
RETURNS INTEGER
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
COLLATION INVOKER INLINE TYPE 1 RETURN
(CASE WHEN A=0 THEN 0
ELSE 2 END);

This SET SESSION UDFSEARCHPATH statement will first search functions, then SYSLIB, and finally TD_SYSFNLIB for bitor:

SET SESSION UDFSEARCHPATH = functions, SYSLIB, TD_SYSFNLIB FOR FUNCTION = bitor;