Previous Topic: Saving and Using DQL Mode SetsNext Topic: Cautions


Uses for Sets

You can use saved sets to speed processing by pressing the USE PF key to activate the saved set. (It becomes the active found set.) Once a set is active, the query that finds it can be executed without re-finding the data, saving search and retrieval time.

Saved sets can be made active and then extracted (EXTRACT command) to save the data itself.

Before you can save or extract a set, it must be active (active found set). Activate a set by executing a query or pressing the USE PF key during Directory of Saved Set display.

Options

KEEP

Use the KEEP command to save search and retrieval time the next time you execute a query or dialog. During display of output, enter KEEP on the command line and press Enter. Only one KEEP per active found set is allowed. See the CA Dataquery Reference Guide for complete instructions.

EXTRACT

Enter EXTRACT on the command line when the set whose data you want to save is active (after executing a query or after using the USE key to make a saved set active). This saves the data printed or displayed by the query as a special format database file that can be accessed by other products. See the CA Dataquery Reference Guide for complete instructions.

<PF4> USE

During display of the Directory of Saved Sets, place the cursor on a saved set name (labeled K, for KEEP) to activate the set and press <PF4> USE. You can then use it in execution or for extraction.