IDXFORMAT

Syntax:

IDXFORMAT = integer

Parameters:

0: Default format for the operating system (identical to 8)
1: C-ISAM
3: Micro Focus default indexed file format
4: Optimized format for fast duplicate key handling
5: Btrieve with ANSI
6: Btrieve without ANSI
8: Large indexed file format
9: Indexed with single key, non-duplicate, key ordered records
10: Reserved
11: Mainframe print file format
12: Large indexed file format with separate index file
13: Reserved
14: Heap file
15: ESDS
16: Extended ESDS
17: Vision
18: Microsoft SQL Server
19: Oracle
20: DB2
21: RM
22-255: Reserved

Properties:

Default:

0

Comments:

By default, IDXFORMATs 17-21 are unavailable under Enterprise Server. You must ensure the ACUFH and ESACUFH configuration options are both set to ON to use these formats.

You can set IDXFORMATs 17-21 under all tags in the configuration file except the [XFH-DEFAULT] tag.

In cases where the INTEROP and IDXFORMAT settings conflict, the INTEROP setting will override IDXFORMAT.

If you are using Fileshare, IDXFORMATs 17 and 21 do not provide transaction processing capabilities by default. You must configure it on a file-by-file basis using the Virtual File Handler option (/ap) when specifying the file in your database reference file. For example, when you access the following file through Fileshare, it is additionally re-directed to the ACUFH file handler, where transactional support can be provided:

Fs /d dbase.ref /f acufile1.dat /ap ACUFH

Rebuild will not take the setting of this configuration option into account when generating a new file. Refer to the Rebuild Options /t topic in the Reference section for further information.

You can also set the index format using the IDXFORMAT Compiler directive, which will override the setting specified in the file handler configuration file.