Previous Topic: Creating a Personal Table from OutputNext Topic: Uses for Sets


Saving and Using DQL Mode Sets

CA Dataquery lets you save the locations in the database of any data found with a query and it also lets you save the found data itself. The following terms are used in this chapter.

Definitions

Active found set

Directions to the location of database information found by the last executed query during the current CA Dataquery session or the last saved set activated. A set is active until you execute another query, use another saved set, or sign off.

Saved set

Saved set of directions to location of data found by an executed query. Saved sets remain intact even after you sign off CA Dataquery. You can access a saved set during another CA Dataquery session.

Extracted set

Saved data found by an executed query. An extracted set contains the values of columns named in the PRINT or DISPLAY statement. Extracted sets cannot be used by CA Dataquery; you create them with CA Dataquery for use by other programs. See the CA Dataquery Administrator for more information.

Directory of Saved Sets

Lists saved sets and extracted sets by name, type, description, date and size. Display the directory when you want to use a saved set or when you want to delete a saved or extracted set.