Use this statement to remove a class or a jar file from a database. When a class is removed it is no longer available for use as a column or variable type.
The class or jar must already be installed.
REMOVE JAVA classes-to-remove
CLASS java-class-name, ... | JAR jar-name, ...
CLASS The java-class-name parameter is the name of one or more Java class to be removed. These classes must be installed classes in the current database.
JAR The jar-name is a character string value of maximum length 255.
Each jar-name must be equal to the jar-name of a retained jar in the current database. Equality of jar-name is determined by the character string comparison rules of the SQL system.
Removes a class or jar file from the database.
Must have DBA authority.
Not supported on Windows CE.
SQL/2003 Vendor extension.
The following statement removes a Java class named Demo from the current database.
REMOVE JAVA CLASS Demo;