1.1

SYSCS_UTIL.SET_EXPLAIN_CONNECTION
Enables or disables capturing query execution plans and statistics for the current connection.
After enabling query execution plan capture, you can optionally enable statistics timing using
SYSCS_UTIL.SET_STATISTICS_TIMING.
Enable query execution plan capture by calling this procedure with a non-zero argument. Disable capture by
calling the procedure with a zero argument. See Capture Query Plans for All Statements on page 268.
Syntax
SYSCS_UTIL.SET_EXPLAIN_CONNECTION(IN SMALLINT ENABLE)
Example
To begin capturing execution plans for the current connection:
CALL SYSCS_UTIL.SET_EXPLAIN_CONNECTION(1);
SYSCS_UTIL.SET_STATISTICS_TIMING
When statistics timing is turned on, you can track the timing of various aspects of a statement execution. When
statistics timing is turned off, all timing values are set to zero.
Statistics timing is an attribute associated with a connection that you turn on and off by using the
SYSCS_UTIL.SET_STATISTICS_TIMING system procedure. Statistics timing is turned off by default.
Turn statistics timing on only when the statistics are being collected with
SYSCS_UTIL.SET_EXPLAIN_CONNECTION. If you turn statistics timing on before enabling statistics
collection with SYSCS_UTIL.SET_EXPLAIN_CONNECTION, the procedure has no effect.
Turn statistics timing on by calling this procedure with a non-zero argument. Turn statistics timing off by calling
the procedure with a zero argument. See Capture Query Plans for All Statements on page 268.
Syntax
SYSCS_UTIL.SET_STATISTICS_TIMING(IN SMALLINT ENABLE)
Example
To enable statistics timing:
CALL SYSCS_UTIL.SET_STATISTICS_TIMING(1);
JAR Installation Procedures
SQLJ.INSTALL_JAR, SQLJ.REMOVE_JAR, and SQLJ.REPLACE_JAR are a set of procedures in the SQLJ
schema that allow you to store jar files in a database.
Your jar file has two names:
• A physical name (the name you gave it when you created it)
• A SQLFire name (the SQLFire identifier that you give it when you load it into a particular schema). The
SQLFire name, an SQL92 identifer, can be delimited and must be unique within a schema.
A single schema can store more than one jar file.
For more information on when and how to use these procedures, see Storing and Loading JAR Files in SQLFire
on page 121.
SQLJ.INSTALL_JAR
The SQLJ.INSTALL_JAR system procedure installs a JAR file in SQLFire.
vFabric SQLFire User's Guide594
vFabric SQLFire Reference