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.

Analyze the MTwoPackageSet project

  1. In the Solution Explorer, double-click the Properties entry for the MTwoPackageSet project.
  2. Click the SQL tab.

    Notice the directive settings for the OpenESQL ESQL Preprocessor include SQL(DBMAN=ADO). This means that the compiler uses an ADO.NET database connection rather than an ODBC database connection.

  3. Close the Properties window.

Build the MTwoPackageSet project

  1. In the Solution Explorer, right-click the MTwoPackageSet project and select Set as StartUp Project from the context menu.
  2. Again, right-click the MTwoPackageSet project, but this time select Build from the context menu.

Bind the TwoPackageSet program

  1. From the HCO for SQL Server interface, go to the Bind Scripts tab of the Manage Packages and Plans tool.
  2. Click Execute All, to execute all of the BIND commands listed.

    Because the application was rebuilt as a .NET application, HCOSS uses the same commands to create and bind the packages and plan to the .NET version of the application.

Run the TwoPackageSet application

  1. From the Solution Explorer in Visual Studio, open the TwoPackageSet.cbl source file.
  2. Set a break point on the STOP RUN line.
  3. Click Debug > Start Debugging to debug the application.

    You should see the same data output that you saw when you ran the TwoPackageSet native application, indicating that the program is switching package sets between row fetches.

This completes the tutorial.