ASA SQL Reference
  SQL Statements

REMOVE JAVA statement

Description 

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.

Syntax 

REMOVE JAVA classes_to_remove

classes_to_remove :
  CLASS java_class_name [, java_class_name, ...]
| JAR jar_name [, jar_name, ...]

Parameters 

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.

Usage 

Removes a class or jar file from the database.

Permissions 

Must have DBA authority.

Not supported on Windows CE.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise. A similar feature is available in an Adaptive Server Enterprise-compatible manner using nested transactions.

Example 

The following statement removes a Java class named Demo from the current database.

REMOVE JAVA CLASS Demo