Tutorial: Application Migration - Switching Package Sets

Guides you through the process of using HCOSS to migrate an application that switches package sets and alternates fetching data using a single cursor name, from DB2 to SQL Server.

This tutorial also demonstrates how, with HCOSS, you can bind the application using the HCOSS Manage Packages and Plans tool.

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 - TwoPackageSet

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

The solution also contains the TwoPackageSet.cbl program, which is a COBOL SQL program that switches between the PROD and TEST package sets.

The demonstration Visual Studio solution and its components are located in the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcoss\TwoPackageSet 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. Analyze the TwoPackageSet Project
    Guides you through the process of analyzing the TwoPackageSet COBOL program and project to become familiar with its use of SQL and to learn how it is compiled for HCOSS.
  2. Bind the TwoPackageSet Program
    Walks you through the steps required to build and bind the TwoPackageSet program, creating two packages and a plan.
  3. Run the TwoPackageSet Application
    Provides step-by-step instructions to run the TwoPackageSet application using the Visual Studio debugger.
  4. Duplicate the Process for the MTwoPackageSet Project
    Provides instructions for running the same steps to analyze, build, bind, and run the MTwoPackageSet application, which is an ADO.NET version of TwoPackageSet.
Parent topic: Tutorials: Application Migration using HCOSS
Related concepts
Tutorials: HCO for SQL Server (HCOSS)
Tutorial: Prepare for Application Migration