Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Allows switching between set-oriented and record oriented fetch modes.

If DF_FILE_SET_MODE is set to True, the driver will fetch a set of records for each find. If DF_FILE_SET_MODE is False, the driver will fetch only one record at a time. This attribute can also be specified in the .INT file during migration through Flex2SQL. This settings is normally used alongside DF_FILE_MAX_ROWS to set the number of rows to return and DF_FILE_CACHE_MODE to turn on local caching.

Note: Turning off set-mode can have a detrimental impact on performance. Unless there is a specific reason to do otherwise, this option should be left on.

Default value: True


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




Number of the file


Mode for the FileNumber. True for set-mode, False for one-row mode.


Open Orderhea
Set_Attribute DF_FILE_SET_MODE of Orderhea.File_Number to True
Get_Attribute DF_FILE_SET_MODE of Orderhea.File_Number to boolVar