Example: Creating a Java Scalar Function - Advanced SQL Engine - Teradata Database

The following request creates a Java scalar UDF named judf_cref012003:

     CREATE FUNCTION judf_cref012003 (
        par1 BIGINT)
     RETURNS BIGINT
     CAST FROM INTEGER
     SPECIFIC judf_cref012003
     LANGUAGE JAVA
     NO SQL
     PARAMETER STYLE JAVA
     NOT DETERMINISTIC
     CALLED ON NULL INPUT
     EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.mybigint(long) 
                    returns int';