The HPL ipload utility icon buttons

Icon buttons appear in the middle sections of the Load Job, Unload Job, and Views windows. The icon buttons represent various components. When you click it, each button opens another display.

The following table shows and describes the icon buttons that are used in these windows.
Component Description Window Action

begin figure description - This figure is described in the surrounding text. - end figure description
Device
The device or device array where the source files are located Load Job, Unload Job
  • If the text box is empty, click the Device button to display the Device Array Selection window, where you can create or open a device type.
  • If the text box has an entry, click the Device button to display the Device Array Selection window for that specific device or type the name of a different device in the text box.

begin figure description - This figure is described in the surrounding text. - end figure description
Filter
The filter that controls which records are selected from the data file for a database update (The use of a filter is optional.) Load Job, Filter Views
  • If the text box is empty, click the Filter button to display the Filter Views window, where you select a filter and associated format. You can also create a filter from this window.
  • If the text box has an entry, click the Filter button to display the Filter-Definition window for that specific filter or type the name of a different filter in the text box.
  • In the Filter Views window, click the Filter button to display the Filter-Definition window for a specific filter.

begin figure description - This figure is described in the surrounding text. - end figure description
Format
The format of the source data used for this load or unload Load Job, Unload Job
  • If the text box is empty, click the Format button to display the Format Views window, where you can select a format and associated map. You can also create a format from this window.
  • If the text box has an entry, click the Format button to display the Format-Definition window for that specific format or type the name of a different format in the text box.
  • In all Views windows, click the Format button to display the format definition for a specific format. In these windows, the button shows only one of the three symbols (F, D, C) to indicate whether the type of format is fixed, delimited, or COBOL.

begin figure description - This figure is described in the surrounding text. - end figure description
Map
The map that correlates fields of the data source to database columns Load Job, Unload Job, Map Views, Format Views, Database Views
  • If the text box is empty, click the Map button to display the Map Views window, where you can select a map and associated table and format. You also can create a map from this window.
  • If the text box has an entry, click the Map button to display the Map-Definition window for that specific map or type the name of a different map in the text box.
  • In a Views window, click the Map button to display the Map-Definition window for a specific map.

begin figure description - This figure is described in the surrounding text. - end figure description
Options
The options that let you specify characteristics of the load or unload Load Job, Unload Job
  • Click the Options button to display the Load Options window.

begin figure description - This figure is described in the surrounding text. - end figure description
Query
The query that selects data from the database table Unload Job, Database Views, Map Views
  • If the text box is empty, click the Query button to display the Database Views window from which you can select the table and associated map and format.
  • If the text box has an entry, click the Query button to display the Query-Definition window for that specific query or type the name of a different query in the text box.
  • In a Views window, click the Query button to display the Query-Definition window for a specific query.

begin figure description - This figure is described in the surrounding text. - end figure description
Table
The database table into which the converted data will be loaded Load Job, Database Views, Query Definition
  • Click the Table button to display the Database Views window from which you can select the table and associated map and format. If an association is not apparent, click Create to create one.
  • Click the Table button in the Query-Definition window to choose a table and columns for the Select entry.