SQLJ.REMOVE_JAR

The SQLJ.REMOVE_JAR system procedure removes a jar file from a database.

For more information about using JAR files, see the Using Functions and Stored Procedures section in our Developer’s Guide.

Syntax

SQLJ.REMOVE_JAR(
		IN qualified_jar_name VARCHAR(32672),
 		IN undeploy INTEGER
		)

qualified_jar_name

The Splice Machine name of the jar file, qualified by the schema name. Two examples:

MYSCHEMA.Sample1
   -- a delimited identifier.
MYSCHEMA."Sample2"

undeploy

If set to 1, this indicates the existence of an SQLJ deployment descriptor file. Splice Machine ignores this argument, so it is normally set to 0.

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

SQL Example

-- SQL statement
CALL SQLJ.REMOVE_JAR('SPLICE.Sample1', 0);

See Also