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).
Parent topic: OpenESQL Assistant
Related concepts
Creating Temporary Files
Embedding SQL into a program
Related tasks
To create a temporary file
To view a temporary file