To specify that the search path of classes for a registered JAR or ZIP file include classes from other JAR or ZIP files registered with the same database, use the SQLJ.ALTER_JAVA_PATH external stored procedure.
Before You Begin
Take the following steps before you alter the Java path of a previously registered JAR or ZIP file for an external routine:
- Verify you have the EXECUTE privilege on the SQLJ.ALTER_JAVA_PATH external stored procedure.
- If the default database is not the same as the default database with which the JAR or ZIP file was registered, use the DATABASE statement to change the default database.
- Verify you have the DROP PROCEDURE or DROP FUNCTION privilege on any of the following objects:
- The default database
- The object within the default database, identified by the SQL identifier that was passed to SQLJ.INSTALL_JAR