Specifying the Class Name, Method Name, and JAR or ZIP Identifier - Advanced SQL Engine - Teradata Database

The CREATE FUNCTION and REPLACE FUNCTION statements provide the EXTERNAL NAME clause for specifying the identifier of the registered JAR or ZIP file, and the class and method name in the JAR or ZIP file that implements the function.

Consider the following CREATE FUNCTION statement:

CREATE FUNCTION factorial (x INTEGER)
   RETURNS INTEGER
   LANGUAGE JAVA
   NO SQL
   PARAMETER STYLE JAVA
   RETURNS NULL ON NULL INPUT
   EXTERNAL NAME 'JarUDF:UDFExample.fact';

where: