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.