f2s_table_invalidate_cache

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

f2s_table_invalidate_cache {File Number}

Parameter

Description

File Number

The number of the file to invalidate the cache (Filename.File_Number).

Description

This command is used to disable the local cache for a table. It takes a file number and invalidates any cached records the driver has for that table.

Note: Turning off the cache can have significant detrimental effects on performance.

Example

f2s_table_invalidate_cache Customer.File_Number

Replaces

DF_FILE_CACHE_MODE