The following table shows the contents of the SYSFILES system table.
SYSFILES system table
For each column in the SYSFILES system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
Column Name
Type
Length
Nullable
Contents
FILEID
CHAR
36
false
Unique identifier for the jar file
SCHEMAID
CHAR
36
false
ID of the jar file's schema (join with
SYSSCHEMAS.SCHEMAID)
FILENAME
VARCHAR
128
false
SQL name of the jar file
GENERATIONID
BIGINT
20
false
Generation number for the file. When jar files are replaced,
their generation identifiers are changed.