Using the Autogenerate Unload Components Window

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 that uses a query to select from one or more tables or that unloads an entire table.

To generate a job that uses a query

Follow the instructions in Creating a Query to create a query.
Choose Jobs > Unload from the HPL main window.
The Unload Job Select window appears, as Figure 103 shows.
Click Create in the Selection Type group.
Select a name for the unload job and type it in the Job Name text box.
Click OK.
The Unload Job window appears, as Figure 104 shows.
Click Generate.
The Autogenerate Unload Components window appears, as Figure 113 shows.

Figure 113. The Autogenerate Unload Components Window
Click Query in the Unload From group.
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.
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, you must first create the file.
Click OK to generate the components of the unload.
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 Figure 114 shows.

Figure 114. The Unload Job Window
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.
To run the job, click Run.
The Active Job window appears, as Figure 23 shows.
When the Active Job window displays Job Completed, click Cancel to return to the main HPL window.

To generate a job that unloads an entire table

Choose Jobs > Unload from the HPL main window.
The Unload Job Select window appears, as Figure 103 shows.
Click Create in the Selection Type group.
Choose a name for the unload job and type it in the Job Name text box.
Click OK.
The Unload Job window appears, as Figure 104 shows.
Click Generate.
The Autogenerate Unload Components window appears, as Figure 113 shows.
Click Table in the Unload From group.
Enter the desired database and table in the Database and Table text boxes, respectively.
You can use the down arrows to see selection lists. When you unload from a table, you do not enter a query.
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.
Click OK to generate the components of the unload.
The Unload Job window reappears, with the components of the job completed.
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.
To run the job, click Run.
The Active Job window appears, as Figure 23 shows.
When the Active Job window displays Job Completed, click Cancel to return to the main HPL window.