Tutorial: OpenESQL Assistant

Guides you through the process of using the OpenESQL Assistant to generate SQL queries and a COBOL application to contain them.

In this tutorial, you create an application using OpenESQL Assistant to generate a skeleton COBOL program, an SQL query to embed into that program, and to generate and embed an INCLUDE statement for a generated copybook that defines host variables. It also takes you through the process of customizing the program code, and debugging the resulting application.

Assumptions

This tutorial is written from the perspective that all of the following is true. Specific instructions for setting up your environment to adhere to these assumptions is found in the Before you begin this tutorial section that follows:

  • Windows File Explorer is set to show file names and extensions.
  • You are running the latest version of Micro Focus Enterprise Developer, which has been installed on your local machine using default installation settings.
  • You have installed and can access a supported version of Microsoft SQL Server.
  • Enterprise Developer is started on your local machine.
  • Your parent project directory is c:\tutorials\SQL. If you choose to use an alternative parent project directory, adjust the instructions accordingly.
  • You have addressed all of the items in the Before you begin this tutorial section below.

Before you begin this tutorial

Install Microsoft SQL Server
To complete this tutorial, you must have Microsoft SQL Server, including the SQL Server Management Studio, installed and configured on your machine. For information on current supported versions, see the OpenESQL section of the Database Management Systems (DBMSs) topic.
Create a working directory to serve as a parent directory for SQL projects
Create a working directory in which to store the projects and other files created or required for this series of tutorials. This tutorial cites a working directory of c:\tutorials\SQL.
Set Windows File Explorer options
These tutorials assume that your Windows File Explorer options are set to use the Details layout, and to show file name extensions. See your Windows documentation for more information.
Start Visual Studio
If you need instructions to get Visual Studio started on your local machine, see To start Visual Studio.

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 the OESQLDemo SQL Server Database
    Provides instructions for using Microsoft SQL Server Management Studio to create a SQL Server database to use in this tutorial, and to create the required schemas and tables.
  2. Set Up the OESQLAsst Project
    Walks you through the steps required to create and configure a Visual Studio project to use for this tutorial.
  3. Set the OpenESQL Assistant Type COBOL Variable
    Provides the steps required to set configuration options for the OpenESQL Assistant.
  4. Catalog a Connection using the ADO.NET Connection Editor
    Guides you through the process of starting the ADO.NET Connection Editor from the OpenESQL Assistant, setting a save option, and cataloging the OESQLDemo connection.
  5. Define and Test a Query
    Provides step-by-step instructions for using the OpenESQL Assistant to define and test an SQL query.
  6. Generate and Embed an SQL Program and Query
    Walks you through the process of using the OpenESQL Assistant to generate a generic COBOL SQL program, embedding the program into an existing COBOL program in the OESQLAsst project, and adding the generated SQL query to the program.
  7. Generate and INCLUDE the EMP.cpy Copybook
    Walks you through the steps required to use the OpenESQL Assistant to generate copybook that contains the table declaration and appropriate data structures, and an EXEC SQL INCLUDE statement to call the copybook from the program.
  8. Debug the SQL COBOL Application
    Guides you through the process of adding the EMP.cpy copybook to the OESQLAsst project, setting a break point, building the application, and debugging the application in Visual Studio.
Parent topic: .NET COBOL Tutorials
Related concepts
OpenESQL Assistant
Related tasks
To start Visual Studio