Column Name
|
Data Type
|
Description
|
TABLE_CAT
|
VARCHAR (128),NULLABLE
|
The catalog that contains the remote table on which the cache is defined. It is NULL for this driver.
|
TABLE_SCHEM
|
VARCHAR (128),NULLABLE
|
The schema that contains the remote table on which the cache is defined.
|
TABLE_NAME
|
VARCHAR (128),NOT NULL
|
The name of the remote table on which the cache is defined.
|
CACHE_TYPE
|
VARCHAR (20),NOT NULL
|
The type cache, which can be either REMOTE TABLE or REMOTE RELATIONAL.
|
REFRESH_INTERVAL
|
INTEGER,NOT NULL
|
The refresh interval (in minutes).
|
INITIAL_CHECK
|
VARCHAR (20),NOT NULL
|
The value that defines when the initial refresh check is performed: ONFIRSTCONNECT or FIRSTUSE.
|
PERSIST
|
VARCHAR (20),NOT NULL
|
The value that defines whether the data in the cache is persisted past the lifetime of the connection: TEMPORARY, MEMORY, or DISK.
|
ENABLED
|
BOOLEAN,NOT NULL
|
The value that defines whether the cache is enabled for use with SQL statements: TRUE or FALSE.
|
CALL_LIMIT
|
INTEGER,NOT NULL
|
The maximum number of Web service calls that can be made when refreshing the cache. The value 0 indicates no call limit.
|
REFRESH_MODE
|
INTEGER,NOT NULL
|
For internal use only.
|
FILTER
|
VARCHAR (128),NULLABLE
|
The Where clause used to filter the rows that are cached.
|
LAST_REFRESH
|
DATETIME, NULLABLE
|
The time, in Coordinated Universal Time (UTC), the cache was last refreshed.
|
STATUS
|
VARCHAR (30)
|
The Cache status. Valid values are:
![]() ![]() ![]() ![]() ![]() |