- Display the query-definition window (Figure 77) by following the steps in Creating a Query.
- Click File.
The Import/Export File Selection window appears, as Figure 82 shows.
- Click Import.
- Specify the file that you want to import.
You can do this in either of the following ways:
- Type a pathname and appropriate wildcards in the Filter text box and click Filter. Use an asterisk (*) to list all of the files in the directory. Then select a file and click OK or double-click a filename.
- Type the full pathname in the Selection text box and then click OK.
The text from the imported file appears in the query-definition window.
If ipload can interpret the SQL statement, the SQL statement is inserted into the appropriate Select, From, and Where text boxes.
If ipload cannot interpret the SQL statement, the entire content of the imported file appears in the Select text box.
- Edit the query so that it meets your needs.
- Click OK.
If the query is a valid SQL query, the display returns to the Query window.
If the query is not a valid SQL query, ipload highlights the portion of the query that it cannot interpret and provides an error message.
- From the Query window, click Cancel to return to the HPL main window.
