SYSCS_DIAG diagnostic tables and functions
Derby Reference Manual
181
CALL SQLJ.REMOVE_JAR('APP.Sample1', 0)
SQLJ.REPLACE_JAR system procedure
The SQLJ.REPLACE_JAR system procedure replaces a jar file in a database.
Syntax
SQLJ.REPLACE_JAR(IN JAR_FILE_PATH_OR_URL VARCHAR(32672),
IN QUALIFIED_JAR_NAME VARCHAR(32672))
JAR_FILE_PATH_OR_URL
The path or URL of the jar file to use as a replacement. A path includes both the
directory and the file name (unless the file is in the current directory, in which case the
directory is optional). For example:
d:/todays_build/tours.jar
QUALIFIED_JAR_NAME
The Derby name of the jar file, qualified by the schema name. Two examples:
MYSCHEMA.Sample1
-- a delimited identifier.
MYSCHEMA."Sample2"
Execute privileges
If authentication and SQL authorization are both enabled, only the
execute privileges on this procedure by default. See "Enabling user authentication" and
"Setting the SQL standard authorization mode" in the Derby Developer's Guide for more
information. The database owner can grant access to other users.
SQL example
-- SQL statement
CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1')
-- SQL statement
-- replace jar from remote location
CALL SQLJ.REPLACE_JAR('http://www.example.com/tours.jar', 'APP.Sample2')
SYSCS_DIAG diagnostic tables and functions
Derby provides a set of system table expressions which you can use to obtain diagnostic
information about the state of the database and about the database sessions.
There are two types of diagnostic table expressions in Derby:
Diagnostic tables
Tables that are like any other table in Derby. You can specify the diagnostic table
name anywhere a normal table name is allowed.
Diagnostic table functions
Functions that are like any other function in Derby. Diagnostic table functions can
accept zero or more arguments, depending on the table function that you use. You
must use the SQL-defined table function syntax to access these functions.
The following table shows the types and names of the diagnostic table expressions in
Derby.
Table 9.
System diagnostic table expressions provided by Derby
