To create a complete program in a temporary file

In the OpenESQL Assistant, connect to a data source.
Click the Auxiliary Code tab.
Click Generic SQL or PL/I Program.
Click Add query to temporary file.
Create additional queries and/or auxiliary code as required for the program, and add each one to the temporary file after generating the code.
Note: OpenESQL Assistant adds generated code to the end of the temporary file each time you click Add query to temporary file.
Edit the temporary file as necessary to ensure that each query and set of auxiliary code appears in its proper location, and that all program code is complete.
Click Save temporary file.
Note: The default filename is the table name followed by a .cbl or .pli extension depending on the Output language specified in the OpenESQL Options.
Add the saved file to your Eclipse project (optional).