Object documentationFILESYSTEMS Locate this document in the navigation structure

 

The system table SYSINFO.FILESYSTEMS describes the existing internal file systems.

Structure

FILESYSTEMS

ID

CHAR(8) BYTE

ID of the internal file system in the database catalog

NAME

CHAR(32)

Local name of the internal file system, which is granted when the file system is imported

PROVIDERID

CHAR(255)

Provider name

SNAPSHOTID

FIXED(10,0)

Snapshot ID

FILESYSTEMINDEX

FIXED(2,0)

Internally granted number of the internal file system, which generally starts at 0 and rises with each granting

CREATEDATE

TIMESTAMP

Date on which the internal file system was imported

COMMENT

CLOB

Comment on the internal file system