Saving a Recent Result Set

 

When you run an SQL query, DB2 Web Query temporarily stores a file containing the query results on the server to which you are connected. You can choose to save each set of query results, or allow it to remain in temporary storage on the server. If you do not save a results set within a set number of days, DB2 Web Query automatically deletes it.

Note:     When installing DB2 Web Query, your network administrator specifies the number of days that elapse before DB2 Web Query automatically deletes temporary results sets. If you are unsure how long your temporary results sets remain on the server before being deleted, consult with your network administrator.

To save a recent result set:

1.         In the desired connection branch of the DB2 Web Query navigation tree, click Results.

The Results branch expands, listing the available Recent and Saved results sets.

2.         Select the recent results set you want to save.

The Results page appears, displaying all recent and saved results sets.

Tip:     Recent results are those in temporary storage on the server; Saved results are stored permanently in the Web Query Catalog.

3.         From the list of recent results sets, select the results set you want to save, and click Save.

DB2 Web Query saves the results set. The results set disappears from the Recent list, and is added to the Saved list.