LucidDbCreateJavaUdf

Syntax

CREATE FUNCTION qualified-function-name ( [ function-param-def, ... ] )
RETURNS data-type
LANGUAGE JAVA
[ PARAMETER STYLE JAVA ]
[ SPECIFIC specific-name ]
[ [ NOT ] DETERMINISTIC ]
[ [ NOT ] DYNAMIC_FUNCTION ]
[ NO SQL | CONTAINS SQL | READS SQL DATA | MODIFIES SQL DATA ]
[ { RETURNS NULL | CALLED } ON NULL INPUT ]
EXTERNAL NAME 'external-name'
[ EXTERNAL SECURITY { DEFINER | INVOKER | IMPLEMENTATION DEFINED } ]

function-param-def ::= param-name data-type

external-name ::= class-spec.java-method-name[(java-param-type, ...)]

class-spec ::= { 
    class fully.qualified.class.name.visible.from.classpath 
    | qualified-jar-name:fully.qualified.class.name.from.jar
}

See LucidDbDataTypes for specification of data-type.

Example

CREATE FUNCTION get_java_property(name varchar(128))
RETURNS VARCHAR(128)
LANGUAGE JAVA
NO SQL
EXTERNAL NAME 'class java.lang.System.getProperty';

See Also

• LucidDbCreateFunction
• LucidDbUdfJavaHowto