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:
- Create a query. (See Creating a query.)
- Open an existing query.
- Import an already prepared query and modify it. (See Importing a query.)
To export a file:
Procedure
- Follow the steps in Creating a query to prepare a query in the Query-Definition window (see The Query-Definition window).
-
Click File.
The Import/Export File Selection window appears (see The Import/Export File Selection window).
- Click Export.
-
Select the directory and file where the query is to be
stored.
- Add the name of a new file to a path name in the Selection text box and click OK.
- Type a path name and appropriate wildcard in the Filter text box and click Filter. Then select a file name.
-
Click OK.
If the file that you specified exists, ipload asks if you want to overwrite the existing file, as the following figure shows.
-
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.
-
Click OK.
The display returns to the Query window.