The following table shows the contents of the SYSFILES system table.
SYSFILES system table
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.