DB2 Universal Database for iSeries SQL Reference

SYSJAROBJECTS

The SYSJAROBJECTS table contains one row for each jarid in the SQL schema. The following table describes the columns in the SYSJAROBJECTS view.

Table 117. SYSJAROBJECTS view

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 function is debuggable.

0
The function is not debuggable.

2
The function is debuggable.
DEBUG_DATA DEBUG_DATA CLOB(1048576)

Nullable
Reserved. Contains the null value.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]