DF_FILE_STATIC¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Activates or deactivates a special table mode where all rows from the table are loaded into a local cache. When active, all searches are done in memory and the actual table is not accessed. The driver does not allow editing of a table in static mode. This is a very useful feature especially when a table contains configuration or static information used in calculations, (i.e., Tax Rate tables, etc.) By keeping this table locally in memory, network round trips are saved resulting in significant performance improvements. This attribute is also useful for batch processes that make extensive table IO requests for reading static information.

Note: Because the entire table is loaded into memory, it is inadvisable to use this on very large tables.

Default value: False

Syntax

Set_Attribute DF_FILE_STATIC of {FileNumber} to {variable}

Parameter	Description
FileNumber	Number of the file
variable	Static Mode for FileNumber. True for static. False for dynamic.

Example

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