In this step, you code either a procedure or a function in Java, then you compile the resulting Java program. Compilation produces a Class file. You can then test and debug the Class file, using the Java virtual machine at the client, and create a JAR file from the Class file.

In this step, you register the new JAR file in HiRDB.

Registration by a HiRDB administrator:

The HiRDB administrator uses the pdjarsync command.

Registration by the UAP developer:

The programmer uses the INSTALL JAR or REPLACE JAR statement in the embedded language. These SQL statements can be coded in either the pddef file or the UAP, and then executed.

You use the CREATE PROCEDURE or CREATE FUNCTION statement to define an external Java stored routine from the JAR file.

As in the case of executing a stored procedure or a stored function, you execute the SQL by specifying either a CALL statement or a function call. The CALL statement causes a Java method to be executed as a Java stored procedure. The function call causes a Java method to be executed as a Java stored function. The external Java stored routine is executed on the Java virtual machine at the server.