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.