The data conversion tutorial presents an example of one way to convert your data from an existing CICS application running under
Studio Enterprise Edition. For the purposes of this tutorial, you should already have your data files residing in the
Micro Focus file system with the ASCII character set.
This tutorial shows how to:
- Gather information from your existing application describing the COBOL record layout
- Gather information on the key structure of the file
- Create a simple COBOL application with a SELECT and FILE DESCRIPTOR for the file
- Compile the COBOL application to generate an eXtended File Descriptor (XFD) that map your data from the record-oriented COBOL application to a relational database’s column-oriented format
- Use your newly created COBOL application to generate an empty database table in Microsoft SQL server
- Verify the table format
- Enhance the sample application to load the data from your
Micro Focus data file into the newly created Microsoft SQL Server table