Importing a query

You can use the Import/Export File Selection window to import a query that you prepared outside of the High-Performance Loader (HPL).

To import a query:

  1. Display the Query-Definition window by following the steps in Creating a query.
  2. Click File.
    The Import/Export File Selection window appears, as the following figure shows.
    Figure 1. The Import/Export File Selection window
    begin figure description - This figure is described in the surrounding text. - end figure description
  3. Click Import.
  4. Specify the file that you want to import.
    1. Type a path name 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 file name.
    2. Type the full path name 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.

  5. Edit the query so that it meets your needs.
  6. 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.

  7. From the Query window, click Cancel to return to the HPL main window.

Copyright© 2018 HCL Technologies Limited