Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Activates or deactivates the local cache for set-oriented searches.

Through the DF_FILE_CACHE_MODE attribute, we can activate or deactivate the local cache. When the cache is active in a set-oriented search, a fixed number of records are pre-fetched and kept in the local cache. If a record is not found in the local cache, a new set is fetched. The number of records fetched is controlled via the DF_FILE_MAX_ROWS attribute. Set-mode vs. one-row mode is controlled via the DF_FILE_SET_MODE attribute.

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

Default value: True


Set_Attribute DF_FILE_CACHE_MODE of {FileNumber} to {variable}
Get_Attribute DF_FILE_CACHE_MODE of {FileNumber} to {variable}




Number of the file


Mode for FileNumber. True for active. False for inactive.


Open Orderhea
Set_Attribute DF_FILE_CACHE_MODE of Orderhea.File_Number to True
Get_Attribute DF_FILE_CACHE_MODE of Orderhea.File_Number to boolVal