Definition
REPLACE PROCEDURE SQLJ.ALTER_JAVA_PATH (IN jarname VARCHAR(128) CHARACTER SET UNICODE, IN path VARCHAR(1000)) LANGUAGE C NO SQL PARAMETER STYLE SQL EXTERNAL NAME 'SL!xsplib';
where:
- jarname
- SQL identifier that was passed to SQLJ.INSTALL_JAR, enclosed in apostrophes.
- path
- Other registered JAR or ZIP files to search when resolving class references for the archive file specified by jarname.
Example: SQLJ.ALTER_JAVA_PATH External Stored Procedure
The following statements specify that the search path of classes in the JAR file that has an SQL identifier called Accounts_JAR include classes from the JAR file that has an SQL identifier called Orders_JAR and classes from the JAR file that has an SQL identifier called Sales_JAR:
DATABASE JXSP; CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', '(*,Orders_JAR) (*, Sales_JAR)');
You can use any of the following statements to remove all classes from the search path of classes in the JAR file that has an SQL identifier called Accounts_JAR:
CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', ''); CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', ' '); CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', '()'); CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', '( )'); CALL SQLJ.ALTER_JAVA_PATH('Accounts_JAR', '() ');