To embed an SQL query into a program

In the Eclipse IDE, open the project that contains the program into which you want to embed the SQL.
Open the appropriate program in the program editor.
In the OpenESQL Assistant, create an SQL query.
Click Add query to temporary file.
In the program editor, place your cursor at the point in your program where you want the query to appear; then right-click and select Paste.