DB2 graphic  QMF Version 8

Saving a new query

You can save your query in the database after you create it. You can run a saved query and display the report again. You can add, delete, or change the information in a saved query.

To save a query: On the QMF command line on the Prompted Query panel, enter:

SAVE

QMF prompts you for the name to assign to the query.

You can also enter:

SAVE AS queryname

For example, to save your query in the database and name it MYQUERY, enter:

SAVE AS MYQUERY

To save a query and share it with other users, add the SHARE=YES parameter to the SAVE command you are using as follows:

SAVE (SHARE=YES 
SAVE AS queryname (SHARE=YES

QMF saves your query in the database. The Prompted Query panel displays with the name you gave the query. If you issue a SET GLOBAL command with the value DSQEC_SHARE=1 before issuing the SAVE command, the SHARE=YES parameter is not needed.

In some cases, a long report might not be complete when you attempt to save your query. When this happens, QMF cannot save the query until the report is complete. This could create performance problems. The global variable DSQEC_RESET_RPT allows you to predefine how you want QMF to handle this situation. See DB2 QMF Reference for more information.


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