There are two ways of creating VQL procedures:
In Java: Virtual DataPort has a Java API to do this. See Developing Stored Procedures - Developer Guide.
In a procedural language. See Developing VQL Stored Procedures
This section explains how to import into Virtual DataPort stored procedure developed in Java.
<DENODO_HOME>/samples/vdp/storedProcedures path contains several
examples of Java stored procedures. The
README file in this path
describes what they do and contains instructions to compile and install
them. The stored procedure
CalculateAvgRevenue, included in these
examples, will be used in this section.
To follow this example, you must:
Execute the script
Load the following Jar file using the Extension Management option:
<DENODO_HOME>/samples/vdp/storedProcedures/target/jars/denodo-demo-storedprocedures.jar. This option is located in the menu File > Extension Management. See section Importing Extensions for more information.