To generate and embed auxiliary code

Open the project that contains the program into which you want to embed the SQL.

Open the appropriate program in the program editor.

Place your cursor at the point in your program where you want the auxiliary code to appear.

In the OpenESQL Assistant, click the Auxiliary Code tab.

Click EXEC SQL.

Click Add query to temporary file .

Click View temporary file Insert query into program

.

Copy the code in the temporary file, and paste it into your program.