|
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 | Column type | Column constraint |
|---|---|---|
| jar_id | INTEGER | NOT NULL |
| object_id | UNSIGNED BIGINT | NOT NULL |
| creator | UNSIGNED INT | NOT NULL |
| jar_name | LONG VARCHAR | NOT NULL |
| jar_file | LONG VARCHAR | |
| update_time | TIMESTAMP | NOT NULL |
jar_id A unique number identifying the JAR file.
object_id The internal ID for the JAR file, uniquely identifying it in the database.
creator The user number of the creator of the JAR file.
jar_name The name of the JAR file.
jar_file The external file name of the JAR file within the database.
update_time The time the JAR file was last updated.
PRIMARY KEY (jar_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL