Each row in the SYSJAR system view defines a JAR file stored in the database. The underlying system table for this view is ISYSJAR.
| Column name | Data type | Description |
|---|---|---|
| jar_id | INTEGER | A unique number identifying the JAR file. |
| object_id | UNSIGNED BIGINT | The internal ID for the JAR file, uniquely identifying it in the database. |
| creator | UNSIGNED INT | The user number of the creator of the JAR file. Can be set by the AS USER clause of the INSTALL JAVA statement. |
| jar_name | LONG VARCHAR | The name of the JAR file. |
| jar_file | LONG VARCHAR | This column is no longer used and contains NULL. |
| update_time | TIMESTAMP | The local time the JAR file was last updated. |
| update_time_utc | TIMESTAMP WITH TIME ZONE | The UTC time the JAR file was last updated. |
PRIMARY KEY (jar_id)
FOREIGN KEY (object_id) REFERENCES SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
UNIQUE INDEX (jar_name)