REMOVE JAVA statement

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, ... | JAR jar-name, ...
Parameters

  • CLASS clause   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 clause   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.

Remarks

Removes a class or jar file from the database.

Permissions

  • Must have DBA authority.

  • Not supported on Windows Mobile.

Standards and compatibility

  • SQL/2003   Vendor extension.

Example

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

REMOVE JAVA CLASS Demo;
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1