Generating a job that uses a query

When you generate from the Unload Job window, ipload creates a format, a map, a job, and, if needed, a device array. You can generate an unload job that uses a query to select from one or more tables or that unloads an entire table.

About this task

To generate a job that uses a query

Procedure

  1. Follow the instructions in Creating a query to create a query.
  2. Choose Job > Unload from the HPL main window to display the Unload Job Select window.
  3. Click Create in the Selection Type group.
  4. Select a name for the unload job and type it in the Job Name text box.
  5. Click OK to display the Unload Job window.
  6. Click Generate.
    The Autogenerate Unload Components window appears, as the following figure shows.
    Figure 1: The Autogenerate Unload Components window

    begin figure description - This figure is described in the surrounding text. - end figure description
  7. Click Query in the Unload From group.
  8. Enter the name of the query.
    You can use the down arrow to see selection lists. When you unload from a table, you do not enter a query.
  9. Click Device Array or File in the Unload To group.
    • If you click Device Array, you can use the down arrow to see a list of the available device arrays.
    • If you click File, ipload creates a device array of the same name as the unload job and inserts the specified file into that device array.
    Important: If you are executing onpload from the command line during an unload job, you must first create the file.
  10. Click OK to generate the components of the unload job.
    The display returns to the Unload Job window. The ipload utility completes the Unload Job window. If you chose cust_out for the unload job name (step 4), the Unload Job window appears as the following figure shows.
    Figure 2: The Unload Job window

    begin figure description - This figure is described in the surrounding text. - end figure description

  11. Click Save to save this Unload Job.
    You can click Run to run the job, or click Cancel to exit and run the job later.
  12. To run the job, click Run to display the Active Job window.
  13. When the Active Job window displays Job Completed, click Cancel to return to the main HPL window.