- Requirements
- Before attempting this tutorial, you must complete the following tutorials in the order listed:
- Tutorial: Create a SQL Server Database
- Tutorial: Create and Configure
a Visual Studio Project
- Tutorial: Set OpenESQL Assistant Configuration Options
- Tutorial: Catalog a Connection
- Tutorial: Build and Test a Query
- Tutorial: Generate and Embed an SQL Program
- Tutorial: Provide Additional Code
- Add the Generated Copybook to the Project
- While the OpenESQL Assistant generated and saved the copybook necessary to compile the application, it does not automatically add the file to the current project. The copybook must be part of the project to be included in the compiled application.
- From the Solution Explorer, right-click the
OESQLAssistantTutorial project and select
Add >
Existing Item.
- Select
EMP.cpy; then click
Add.
The EMP.cpy copybook is added to the project.
- Add a Break Point
- The program sends output to the console, and you want the application to pause at the point where you can see the output.
- If it isn't already in the program editor, double-click
Program1.cbl from the
Solution Explorer to call it up into the program editor.
- In the program editor, scroll down to the following statement:
EXEC SQL DISCONNECT CURRENT END-EXEC
- Place your cursor on the EXEC SQL statement; then press
F9 to toggle a break point.
- Save
Program1.cbl.
- Build the Application
-
- From the Solution Explorer, right-click the
OESQLAssistantTutorial project and select
Build.
- Debug the Application
-
- Press
F5 to start debugging.
- If the console is not visible, minimize
the Visual Studio IDE. You should see the console output.
- Press
F5 again to complete the debugging process.
This completes the OpenESQL Assistant tutorials.