Home | Previous Page | Next Page   Defining Queries > Exporting and Importing Queries >

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 77).
  2. Click File.

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

  3. Click Export.
  4. Select the directory and file where the query should be stored.

    You can do this in either of the following ways:

    • Add the name of a new file to a pathname in the Selection text box and click OK.
    • Type a pathname and appropriate wildcard in the Filter text box and click Filter. Then select a filename.
  5. Click OK.

    If the file that you specified already exists, ipload asks if you want to overwrite the existing file, as Figure 83 shows.

    Figure 83. The Confirm File Overwrite Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - 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 filename.

    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.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]