MAX_DAT_KEY <Max Indexes per Data File>
Maximum number of indexes per data file. This keyword defaults to 64. It can be increased to a theoretical limit of 32767, although a practical limit exists well before this value.
The typical error code that would be seen if this limit is too low is error 107, IDRK_ERR "Too many keys for ISAM data file."
Note: In the standalone model, MAX_DAT_KEY is a compile-time setting, so the code must be recompiled if this setting is changed.
Occasionally data files require a large number of indexes. Commencing with FairCom DB V10.3, the number of indexes default limit was increased from 32 to 64. Customers using the FairCom Server can use the MAX_DAT_KEY keyword to change the limit on the number of indexes per data file.
If this limit is too low, the typical error code that would be seen is error 107, IDRK_ERR "too many keys for ISAM data file."
This value affects the amount of memory that is allocated to store ISAM index state information. It can be increased without a major impact on performance unless FairCom Server is being run in an environment with very little memory (e.g., certain embedded applications).
Note: In the standalone model, MAX_DAT_KEY is a compile-time setting. If this value is changed, the code must be recompiled with the new setting.