SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure

The SYSCS_UTIL.SYSCS_REGISTER_TOOL system procedure loads and unloads optional tools packages.

Syntax

SYSCS_UTIL.SYSCS_REGISTER_TOOL(IN TOOLNAME VARCHAR(128), 
                               IN REGISTER BOOLEAN, 
                               IN OPTIONALARGS VARCHAR(128) ... )

No result set is returned by this procedure.

TOOLNAME
The name of the optional tool. Must be one of the following case-sensitive names: 'databaseMetaData', 'foreignViews', 'luceneSupport', 'simpleJson', or 'rawDBReader'.
REGISTER
A value of true tells Derby to load the tool. A value of false tells Derby to unload the tool.
OPTIONALARGS
Optional case-sensitive string arguments specific to each tool.

Execute privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this procedure by default. See "Configuring user authentication" and "Configuring user authorization" in the Derby Security Guide for more information. The database owner can grant access to other users.

Usage

The following optional tools are supported:

See the Derby Tools and Utilities Guide for more information on how to use these tools. Before you run an optional tool, make sure that your classpath contains the Derby jar files, including derbytools.jar.