The following SELECT statement retrieves information about all of the JARs owned by a given user or database on which dependent external Java routines are defined. Information about these routines is also returned.
SELECT * FROM sqlj.routine_jar_usage;
Result:
DatabaseId 0000B905 JarName JAR1 RoutineName MYINT Signature (I[I)V DatabaseId 0000B905 JarName JAR2 RoutineName MYDEC Signature (Ljava/math/BigDecimal;[Ljava/math/BigDecimal;)V DatabaseId 0000B905 JarName JAR3 RoutineName MYVARBYTE Signature ([B[Ljava/lang/String;)V