SYSJAROBJECTS

The SYSJAROBJECTS table contains one row for each jarid in the SQL schema.

The following table describes the columns in the SYSJAROBJECTS table.

Table 1. SYSJAROBJECTS table
Column Name System Column Name Data Type Description
JARSCHEMA JARSCHEMA VARCHAR(128) Name of the schema containing the jar_id.
JAR_ID JAR_ID VARCHAR(128) Name of the jar_id.
DEFINER DEFINER VARCHAR(128) Name of the owner of the jarid.
JAR_DATA JAR_DATA BLOB(104857600)

Nullable

Byte-codes for the jar.
IASP_NUMBER IASPNUMBER SMALLINT Specifies the independent auxiliary storage pool (IASP) number.

JAR_CREATED

CREATEDTS TIMESTAMP Jar created timestamp
LAST_ALTERED ALTEREDTS TIMESTAMP

Nullable

Reserved. Contains the null value.
DEBUG_MODE DEBUG_MODE CHAR(1) Identifies whether the routine is debuggable.
0
The routine is not debuggable.
1
The routine is debuggable by the Unified Debugger.
2
The routine is debuggable by the system debugger.
N
The routine is disabled from being debugged by the Unified Debugger.
DEBUG_DATA DEBUG_DATA CLOB(1048576)

Nullable

Reserved. Contains the null value.