Exporting a query

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

About this task

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

To export a file:

Procedure

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

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

  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.