Sets

The KEEP function of CA Dataquery saves the pointers to a set of data selected by an executed query. The EXTRACT function of CA Dataquery saves the actual set of data selected by an executed query. Each user is allocated a certain number of Found Table blocks of storage for his sets. When the user's Found Table blocks are exceeded, any further attempts by the user to perform a KEEP or EXTRACT function, results in an error condition.

Note: KEEP and EXTRACT should only be used on data that is not updated frequently. If the data is updated since the last KEEP or EXTRACT functions, the saved pointers in the KEPT data could point to different data, and the reports that used the extracted data would be in error. (This function is available only in DQL Mode. For information about saving data in SQL Mode, see STORE in the CA Dataquery Reference Guide.)

Administrative Menu

The SET option on the Administrative Menu is a maintenance function that you use to maintain the saved and extracted sets stored in the Found Table (DQF).

It is your responsibility to monitor the listing of your users' sets. You should delete the Found Table blocks of those users who have left the company, or those who have transferred to another department within the company. Also delete those sets that are aging past site standards. You can request your Database Administrator to allocate more blocks to the Found Table (DQF) when there is a valid need.

Directory

When you select the SETS option from the Administrative Menu, or use the SETS command from the command line, CA Dataquery displays a listing of saved sets on the Directory of Saved Sets panel.

A sample Directory of Saved Sets panel follows:

Directory of Saved Sets (DQA60)

 =>
 Place the cursor on the desired name and press the appropriate PFkey
 ------------------------------------------------------------------------DQA60
 DATAQUERY: DIRECTORY OF SAVED SETS
 -----------------------------------------------------------------------------
        USER NAME                   |  NAME    | TYPE  |BLOCKS |DATE ADDED
 -----------------------------------------------------------------------------
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
                                    |          |       |       |
 -----------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN        <PF3> DELETE      <PF4> USE
 <PF5> NOT USED     <PF6>  NOT USED      <PF7> BACKWARD    <PF8> FORWARD

Panel Description

The following list describes each column of the Directory of Saved Sets panel:

USER NAME: ID of user who saved set.
NAME: Name of the saved set.
TYPE: Type of saved set - K is KEEP, E is EXTRACT.
BLOCKS: Number of Found Table blocks used.
DATE ADDED: Date the saved set was added to the Found Table.

PF Keys

The following list describes each PF key for the Directory of Saved Sets panel:

Key	Objective	Result
CLEAR	Return to Main Menu.	Return to Main Menu.
<PF1> HELP	Display HELP panel.	CA Dataquery displays the Help panel.
<PF2> RETURN	Return to previously displayed panel.	Returns you to previously displayed panel or Main Menu.
<PF3> DELETE	Delete saved set.	Deletes saved set.
<PF4> USE	Activate a set for use in a query without reexecuting a find.	Displays Online Execution panel.
<PF5> NOT USED	Not used.
<PF6> NOT USED	Not used.
<PF7> BACKWARD	Scroll to previous page of Saved Sets, if any.	Display previous page of Saved Sets, if any.
<PF8> FORWARD	Scroll to next Saved Set screen, if any.	Display more Saved Set screen, if any.

Note: For more information about the <PF4> USE key, see the CA Dataquery User Guide.