Exporting a query

The File button also allows you to export the query as an SQL statement.

You can prepare a query for export in the following ways:

To export a file:

  1. Follow the steps in Creating a query to prepare a query in the Query-Definition window (see Figure 2).
  2. Click File.

    The Import/Export File Selection window appears (see Figure 1).

  3. Click Export.
  4. Select the directory and file where the query is to be stored.
    1. Add the name of a new file to a path name in the Selection text box and click OK.
    2. Type a path name and appropriate wildcard in the Filter text box and click Filter. Then select a file name.
  5. Click OK.
    If the file that you specified exists, ipload asks if you want to overwrite the existing file, as the following figure shows.
    Figure 1. The Confirm File Overwrite window
    begin figure description - This figure is described in the surrounding text. - end figure description
  6. You now have two choices:
    • Click OK to overwrite. The display returns to the Query window.
    • Click Cancel to choose a different file name.

    The ipload utility writes the text from the Select, From, and Where text boxes into the specified file as a single SQL statement.

  7. Click OK. The display returns to the Query window.

Copyright© 2018 HCL Technologies Limited