DROP JAVA

Purpose

Use the DROP JAVA statement to drop a Java source, class, or resource schema object.

Prerequisites

The Java source, class, or resource must be in your own schema or you must have the DROP ANY PROCEDURE system privilege. You also must have the EXECUTE object privilege on Java classes to use this command.

Syntax

SQLRF54883drop_java::=

Semantics

SQLRF54884JAVA SOURCE

Specify SOURCE to drop a Java source schema object and all Java class schema objects derived from it.

SQLRF54885JAVA CLASS

Specify CLASS to drop a Java class schema object.

SQLRF54886JAVA RESOURCE

Specify RESOURCE to drop a Java resource schema object.

SQLRF54887object_name

Specify the name of an existing Java class, source, or resource schema object. Enclose the object_name in double quotation marks to preserve lower- or mixed-case names.

Example

SQLRF54888Dropping a Java Class Object: Example The following statement drops the Java class Agent, created in "Creating a Java Class Object: Example":

DROP JAVA CLASS "Agent";