LucidDbCreateJar

Syntax

CREATE JAR qualified-jar-name
LIBRARY jar-url
OPTIONS (deployment-option-number);

or (below is SQL/J standard)

CALL sqlj.install_jar('jar-url', 'qualified-jar-name', deployment-option-number);

See FarragoSQLJDeploymentDescriptors for the effect of any deployment descriptors which are present in the jar.

Example

CREATE JAR udf_jar
LIBRARY 'file:${FARRAGO_HOME}/plugin/regex-udf.jar'
OPTIONS(0);

or

CALL sqlj.install_jar('file:${FARRAGO_HOME}/plugin/regex-udf.jar','udf_jar', 0);