The
IDXFORMAT option specifies the format to use when creating indexed files.
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
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 running your program under an Enterprise Server region, IDXFORMATs 17-21 are not supported.
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.