Removes a class, a package, or a JAR file from a database. Removed classes
are no longer available for use as a variable
type. Any class, package, or JAR to be removed
must already be installed.
Syntax
REMOVE JAVA classes_to_remove
classes_to_remove:
{ CLASS java_class_name [, java_class_name ]…
| PACKAGE java_package_name [, java_package_name ]…
| JAR jar_name [, jar_name ]… [ RETAIN CLASSES ] }
Parameters
- java_class_name – he name of one or more Java
classes to be removed. Those classes must be
installed classes in the current database.
- java_package_name – he name of one or more Java
packages to be removed. Those packages must be the
name of packages in the current
database.
- jar_name – 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.
- RETAIN CLASSES – the specified JARs are no longer
retained in the database, and the retained classes
have no associated JAR. If RETAIN CLASSES is
specified, this is the only action of the
REMOVE
statement.
Examples
- Example 1 – remove a Java class named “Demo” from the current database:
Standards
SQL—Vendor extension to ISO/ANSI
SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise. A similar feature
is available in an Adaptive Server Enterprise-compatible
manner using nested transactions.
Permissions
Requires one of:
- MANAGE
ANY EXTERNAL OBJECT system privilege.
- You own the object.