Steps to convert Micro Focus COBOL data to Database Layout

In order to convert your data from a COBOL file format to a RDBMS format, you must do the following simple steps (after installing DBMaker):

  1. Create a DCI configuration file

    2. In order for the COBOL program to talk to the database, there must be a map from the COBOL files to the database table. This step is accomplished using an already defined option within the Acucorp compiler.

  2. Set the environment and cblconfi

    3. The runtime will need to know where to look for the database. Also, information, such as logon to the database, will need to be setup.

  3. Convert your data

    4. CASEMaker has developed, with our partners, a program dcimigrate.acu. As the database knows both the COBOL structure and the SQL Table structure (see step #1), this migration program reads the files (using the COBOL structure), and then writes (INSERT) into the table (using the Table structure). This can be done in a single pass, or, based on data availability, by file or subsystem.

  4. Run the application

    The structure is created, the tables are entered. You are ready to run the application.

CASEMaker has developed an example application to show the migration. It includes an Micro Focus COBOL application that is tied to Micro Focus supported file structure, as well as instructions and DBMaker DCI, so you can step through the conversion process. If you would like this sample emailed to you, or you have any questions about this process, please contact us immediately.