To create a complete program in a temporary file

  1. In the OpenESQL Assistant, connect to a data source.
  2. Click the Auxiliary Code tab.
  3. Click Generic SQL or PL/I Program.
  4. Click Add query to temporary fileInsert query into program.
  5. 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 fileInsert query into program.
  6. 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.
  7. Click Save temporary fileInsert query into program.
    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.
  8. Add the saved file to your Eclipse project (optional).