SET SESSION UDFSEARCHPATH Example | Teradata Vantage - Example: SET SESSION UDFSEARCHPATH - Advanced SQL Engine - Teradata 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;