When you start ipload, the HPL main window appears, as Figure 28 shows. The HPL main window is the focus of the user interface. You return to the main window after each task and choose a new option.
When you first enter ipload, you can:
For information on how to create a project, see Creating a New Project.
For information about how to choose a database server, see Selecting a Database Server.
After you select a project, you can choose options from any of the menus on the HPL main window. The following list describes each of the menu options.
| Main Menu
Option |
Submenu
Option |
Purpose | Page |
|---|---|---|---|
| Jobs | Load | Create a load job and use the Load Job window to load data into a database. | Loading Data to a Database Table |
| Unload | Create an unload job and use the Unload Job window to unload data from a database to a file. | Creating an Unload Job | |
| Exit | Exit from the user interface. | The ipload Utility | |
| Browsers | Record | Review records in a specified format, search the list of available formats, or edit a format. | Reviewing Records That the Conversion Rejected |
| Violations | View records that passed the filter and conversion but were rejected by the database. | Viewing the Violations Table | |
| Logfile | View load status and see where any errors occurred. | Viewing the Status of a Load Job or Unload Job | |
| Components | Formats | Create or modify data-file formats. | Defining Formats |
| Maps | Create or modify maps that show the relationship between data-file fields and database columns. | Defining Maps | |
| Query | Build, modify, or retrieve SQL-based queries. | Queries | |
| Filter | Create or modify filters that determine source data-file records for conversion and load. | Defining Filters | |
| Devices | Specify a set of files, tapes, or pipes (UNIX only) that will be read simultaneously for loading or unloading the database. | Defining Device Arrays | |
| Generate Job | Automatically generate the components for load and unload jobs. | Generate Options | |
| Configure | Server | Select the database servers that hold the onpload database and the target database. | Configuring the High-Performance Loader |
| Project | Create a project under which formats, filters, queries, maps, and load and unload jobs are stored. | Defining Projects | |
| Defaults | Specify the default character sets for the data file and databases. | Modifying the onpload Defaults | |
| Machines | Specify the machine parameters that are used to convert binary data. | Modifying the Machine Description | |
| Help | Glossary | View definitions of terms that pertain to the HPL. | Using the Online Help |
| Contents | View the main contents page that directs you to discussions of various HPL topics. | Using the Online Help |