DB2 graphic QMF Version 8

Saving and opening queries

You can save queries on your PC, on a file server, or at a database server. A query is saved in the format that is currently being used to view the query. For example, if the query is being viewed in the prompted interface, it will be saved in the prompted format. If the SQL statements are being viewed, then the query will be saved in the SQL format. A saved query opens in the format in which it has been saved.

Saving queries to files

  1. Create a query.
  2. Select Query--> Save to file.
  3. Type the query name.
  4. Click OK.

Opening saved SQL query files

  1. Select Open--> From File.

    The Open dialog box opens.

  2. Select the file to open.
  3. Click OK.

Saving SQL queries at the database server

Queries saved at the server so they are accessible to other users.

  1. Open a query.
  2. Select Query--> Save at Server.
  3. Type an owner and a name.
  4. Check the Share the object with other users check box to share the query with others.
  5. Click OK.

Opening queries saved at the database server

You can open queries that have been saved at the database server.

  1. Click Open--> From Server.

    The Open From Server dialog box opens.

  2. Type a server, owner, and name.
  3. Click OK.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004