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.

Generate a generic SQL Pprogram

In the OpenESQL Assistant, click the Auxiliary Code tab.
From the Statement Type drop-down list, select Generic SQL Program.
OpenESQL Assistant generates a generic SQL program in the Generated Auxiliary Code box on the Auxiliary Code tab.

Replace the code in Program1.cbl with the code generated by the OpenESQL Assistant

On the Solution Explorer in Visual Studio, double-click Program1.cbl.
This opens the file in the COBOL Editor with the cursor placed at the very beginning of the file.

Note: The Program1.cbl program file was automatically generated and added to the OESQLAsst project when the project was created.
Select and delete all text in the file.
Switch to the OpenESQL Assistant window.
In the OpenESQL Assistant, with the Auxiliary Code tab showing in the right pane, click Insert query into program ().
Switch back to Program1.cbl in the COBOL Editor.
You can see that the generated code now appears in Program1.cbl.
Click Save () to save the program file. Do not close the COBOL Editor.

Embed the SQL Query into program1.cbl

In Visual Studio, in the COBOL Editor, place the cursor on the line just after the comment:
```
*> Put your program logic/SQL statements here
```
On the OpenESQL Assistant, click the Query tab; then click Insert query into program () from the toolbar.
Switch back to Program1.cbl in the COBOL Editor.
You can see that the generated query code now appears in Program1.cbl.
Click Save () to save the program file. Do not close the COBOL Editor.