The following CREATE FUNCTION request invokes the external UDF my_external_udf from its RETURN statement.
CREATE FUNCTION test.udf (a INTEGER) RETURNS INTEGER LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.udf CALLED ON NULL INPUT SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN a + SYSLIB.my_external_udf();