Cloudscape System Tables
Page 9 of 17

SYSFILES

Describes jar files stored in the database.

Column Name

Type

Length

Nullability

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

LONGINT


false

Generation number for the file. When jar files are replaced, their generation identifiers are changed.

Indexes

  • SYSFILES_INDEX1 unique BTREE index on (FILENAME, SCHEMAID)
  • SYSFILES_INDEX2 unique BTREE index on (FILEID)