SET SESSION UDFSEARCHPATH Example | VantageCloud Lake - Example: SET SESSION UDFSEARCHPATH - Teradata Vantage

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 first searches functions, then SYSLIB, and finally TD_SYSFNLIB for bitor:

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