Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
MFDBFH (Known Issues)
There are a number of limitations to the Micro Focus Database File Handler currently. Some of the limitations may be permanent due to the database technologies in use, and some may just be temporary as the database file handling capabilities are developed.
The following is a list of current limitations:
- The order in which duplicate keys in an indexed file are returned differs between disk-based and database-hosted files. For files stored on disk, duplicate keys are always returned in the order they were written in; for files stored in a database, they are returned in the order of the associated primary key.
- The supported key types are currently limited to alphanumeric, binary, and numeric.
- PostgreSQL does not support EBCDIC collating sequences - see Configure Datastores for Db2 for a way to work around this.