Micro Focus Native Database File Handling

The Micro Focus Database File Handler (or MFDBFH for short) is a file handler that enables your COBOL Server service-oriented applications to interact with data files and certain infrastructure files stored within a database.

Applications that use this file handler require no changes to their file handling source code, but you are required to make a number of changes to the environment in which those applications run.

Broadly speaking, you are required to:

  • Configure a number of ODBC data sources or connection strings.
  • Maintain a configuration file that references the sources and connections.
  • Configure enterprise server regions and/or applications to use the data sources\connections, to connect to data files within a datastore database.
  • If you are using database-hosted data files, you must also create and configure the datastores, using the command line utility dbfhdeploy to upload existing or create new data files in a datastore database.

Additionally, if your MFDBFH-enabled application is standalone (that is, does not utilize a COBOL Server), you must ensure that it is compiled with the INITCALL"DBFHINIT" Compiler directive, in order to register the SQL-specific syntax required by MFDBFH; see Accessing MFDBFH-Hosted Data from a Standalone COBOL Program.

If you intend to run an MFDBFH-enabled application through a COBOL Server, an additional license must be purchased; contact your usual account manager for details. If you are using Visual COBOL to develop an MFDBFH-enabled application, the licensing requirements are covered by the main product license.

MFDBFH currently supports Microsoft SQL Server, Microsoft Azure, PostgreSQL, Db2, and Oracle as the database solution.