Working with Data Files in a Database

Restriction: Currently, this feature only supports KSDS formatted VSAM files.

The Micro Focus Database File Handler (MFDBFH) enables you to store data sets and other data files in one of the supported relational database management systems (RDBMS); see System Requirements in the MFDBFH documentation for more information.

The files are stored in databases called datastores, and you can create connections within the Data Explorer to one or more of these datastores, which then allows you to open database-hosted files in the Data File Editor.

To connect to a database, you must ensure that the the MFDBFH_CONFIG environment variable specifies a database configuration file containing the datastore connection details. By default, this variable defaults to a file named mfdbfh.cfg in the current working directory. If the file is located elsewhere and/or has a different name, the variable must be set to the full path and file name. If you are opening the Data File Editor from the IDE, set MFDBFH_CONFIG as a system variable before opening the IDE. See The Database Configuration File for more details on configuring this file.
Note: To save new data files to a datastore, you must use the upload process detailed in Datastore Management.