Now that the SQL query has been generated, you can use OpenESQL Assistant to generate a generic COBOL program and embed the
query right into it.
- 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
an Eclipse Project
- Tutorial: Set OpenESQL Assistant Configuration Options
- Tutorial: Catalog a Connection
- Tutorial: Build and Test a Query
- Generate a Generic SQL Program
-
- 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.
- Embed the Generic SQL Program into the Eclipse Project
- We're now ready to embed our generic SQL program into the current Eclipse project.
- From the
Auxiliary Code tab, click
Add Query to temporary file.
- Click
Save temporary file to disk, and browse to the directory contains the
Program1.cbl file you created earlier.
- Select
program1.cbl; then click
Save. A prompt appears, asking if you want to replace the current file.
- Click
Yes.
- Change to the Eclipse IDE. A prompt appears to tell you that the file contents have changed.
- Click
Yes. The program now appears in the Eclipse IDE program editor. Eclipse automatically saves the file.
- Embed the SQL Query
- Next, you embed the generated SQL query into
Program1.cbl.
- From the OpenESQL Assistant, click the
Query tab; then click
Add Query to temporary file.
- In the COBOL Editor, place the cursor on the line just after the comment:
*> Put your program logic/SQL statements here
- Right-click; then select
Paste.
OpenESQL Assistant inserts the query into the program.