Created On:  29 March 2011

Problem:

What is the limit on the size of a single record in an indexed file under Server Express?

Resolution:

By experimentation using Server Express v5.1 WrapPack4 on Red Hat Linux, SupportLine has determined that the limits on the size of a single record in an indexed file are:

Exactly 32k, meaning 32*1024=32768, when using the default IDXFORMAT, (which is IDXFORMAT=0 resulting in a file of type C-ISAM), and this limit is enforced at runtime by the file handler, and

Exactly 62K, meaning 62*1024=63488, when using IDXFORMAT=4 or IDXFORMAT=8, and this limit is enforced by the compiler itself and not at runtime.
Incident #2459802