LucidDbCreateJavaUdx
From Eigenpedia
Syntax
CREATE FUNCTION qualified-udx-name ( [ udx-param-def, ... ] )
RETURNS TABLE ( udx-result-column, ... )
LANGUAGE JAVA
PARAMETER STYLE SYSTEM DEFINED JAVA
[ SPECIFIC specific-name ]
[ [ NOT ] DETERMINISTIC ]
[ [ NOT ] DYNAMIC_FUNCTION ]
[ NO SQL | CONTAINS SQL | READS SQL DATA | MODIFIES SQL DATA ]
EXTERNAL NAME 'external-name'
[ EXTERNAL SECURITY { DEFINER | INVOKER | IMPLEMENTATION DEFINED } ]
udx-param-def ::= param-name { data-type | CURSOR | SELECT FROM cursor-param-name }
udx-result-column ::= { unqualified-column-name data-type | cursor-param-name.* }
See LucidDbDataTypes for specification of data-type.
See LucidDbCreateJavaUdf for specification of external-name.
Example
CREATE FUNCTION digest(c CURSOR) RETURNS TABLE(c.*, row_digest INTEGER) LANGUAGE JAVA PARAMETER STYLE SYSTEM DEFINED JAVA NO SQL EXTERNAL NAME 'class net.sf.farrago.test.FarragoTestUDR.digest';
