Home | Previous Page | Next Page   Unloading Data from a Database > Unload Job Windows >

Creating an Unload Job

Use the Unload Job Select and Unload Job windows to create a new unload job.

To create an unload job
  1. Choose Jobs > Unload from the HPL main window.

    The Unload Job Select window appears, as Figure 103 shows.

    Figure 103. The Unload Job Select Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  2. Click Create in the Selection Type group.
  3. Choose a name for this unload job and type the name in the Job Name text box.
  4. Optionally check the Write/read to/from tape until end of device check box. For more information, see Specifying to Write to the End of the Tape.
  5. Click OK.

    The Unload Job window appears, as Figure 104 shows. Using the High-Performance Loader Windows, provides detailed descriptions of the buttons in the Unload Job window.

    Figure 104. The Unload Job Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  6. Type appropriate values for all of the unload components.

    If you click a component button, the corresponding view window opens, and you can create or select the component.

  7. Specify the file that contains rejected records.

    Use one of these methods:

    • Type the name of the rejected file in the Discards Records text box.
    • Click the down arrow next to the Discard Records text box to select the filename from the file-selection list.
  8. Select the file that contains the unload status log.

    Use one of these methods:

    • Type the name of the log file in the Logfile text box.
    • Click the down arrow next to the Logfile text box to select a filename from the file-selection window.
  9. Click Options to change unload options.

    For more information, see Changing the Unload Options.

  10. Click Save to save this unload job. (If you click Run to run the job immediately, the job is saved automatically.)
  11. Now you can either run the unload job or exit and run the job later.
    • Click Run to run the job.
    • Click Cancel to exit to the Unload Job Select window.
Important:
Use Ext Type String Length data type or Ext Type Binary Length data type if you unload data that contains null UDT values.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]