Tutorial: Application Migration - Adding Function Emulation

Takes you through the process of adding SQL function emulation to a DB2 application, and migrating that application from DB2 to SQL Server using HCOSS.
The demonstrated function emulation includes:
  • Adding math functions to SQL Server that represent standard math functions in DB2
  • Mapping the DB2 functions to the new SQL Server functions using the Customize SQL Name Mapping tool

This tutorial also demonstrates binding the application using a post-build event in Visual Studio.

Prerequisites

  • If you have not already done so, review the Assumptions and Before you begin a tutorial section in the Tutorials: HCO for SQL Server (HCOSS) topic to ensure your environment is set up properly.
  • Before attempting this tutorial, you must first work through the steps in Tutorial: Prepare for Application Migration.

Visual Studio solution - FunctionEmulation

The Visual Studio solution we provide for this tutorial contains two HCOSS projects. The FunctionEmulation project is a native COBOL project. The MFunctionEmulation project is a .NET COBOL project. However, the COBOL code is the same in both projects.

The solution also contains the FunctionEmulation.cbl program , which is a COBOL SQL program that does not contain function emulation in its initial form.

The demonstration Visual Studio solution and its components are located in the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcoss\FunctionEmulation directory by default.

Sequence

To complete this tutorial, progress through these topics in the order presented here. The bottom of each topic provides Next topic and Previous topic navigational links to help you proceed in the proper sequence:

  1. Create and Map User-defined Functions
    Guides you through the steps required to create user-defined functions in SQL Server Management Studio, and to map those functions using the HCO for SQL Server Customize Name Mappings tool.
  2. Analyze the FunctionEmulation Project
    Guides you through the process of analyzing the FunctionEmulation COBOL program and project to become familiar with its use of SQL and to learn how it is compiled for HCOSS.
  3. Define and Verify a Post-Build Event that Binds the Application
    Walks you through the process of defining a post-build event that automatically binds the application after building the project.
  4. Run the FunctionEmulation Application
    Provides step-by-step instructions to run the FunctionEmulation application using the Visual Studio debugger.
  5. Duplicate the Process for the MFunctionEmulation Project
    Provides instructions for running the same steps to analyze, build, bind, and run the MFunctionEmulation application, which is an ADO.NET managed version of FunctionEmulation.
Parent topic: Tutorials: Application Migration using HCOSS
Related concepts
Tutorials: HCO for SQL Server (HCOSS)
Tutorial: Prepare for Application Migration