skip to main content
OpenEdge Data Management: DataServer for ODBC
Programming Considerations : Database design issues : Indexes and sorting : Large key entry support
 
Large key entry support
Updates in the OpenEdge database enable existing index key limits, currently set at approximately 200 bytes, to be widened. For example, updates enable databases with a block size of 4K or 8K to support a maximum index key of approximately 2000 bytes. Also, the index key width expansion extends the maximum key size supported in the OpenEdge client that can be used with databases exported to foreign data sources.
When you are migrating OpenEdge keys to a foreign data source, the key sizes cannot be larger than those supported by the foreign data source. Because the maximum OpenEdge key size is data-source dependent, you should consider your target data source's capacity with respect to the maximum OpenEdge key-size capacity before you perform a migration.
Note: The key capacity for most foreign data sources is a function of the index page size used or allowed on the OS platform in which the data source is installed. Refer to documentation supplied by the data source vendor to determine the key size limit applicable to your target database.