Operation Commands › KEEP - Save Found Set Location

KEEP - Save Found Set Location

Purpose

The DQL Mode KEEP command stores the active found set in the Saved Set library. An active found set is a collection of internal database directions to the data found with your most recent query execution during the current session. You may want to KEEP a found set for a query that requires a lengthy search for data. Saving the set allows you to minimize processing time the next time you execute the query while still accessing current data. We advise including the query name as part of the saved set description. (See the CA Dataquery User Guide for more information.) Only one KEEP command per active found set is permitted.

The data itself is not saved with the KEEP command. Therefore, if the data is updated after the set is saved, and the set is then used, the results can change. Other than the STORE command, which creates a personal table of query output, the only way to store current results of query execution so that it is not subject to database maintenance is by using the EXTRACT command online or the Export function during batch execution.

You may want to read about the EXTRACT command which allows other software products to access data found by CA Dataquery. See EXTRACT - Extract Found Data for more information about EXTRACT.

When to Use It

After executing a query that requires a lengthy search for data, you may want to change certain report characteristics and re-execute the query at a later time. KEEP allows you to do this without doing FIND processing again.

Syntax

Example

 => keep
 
01/04/2010          DATAQUERY SAMPLE                      PAGE 1
14:17:22                                                             DETAIL
 
  ORD-ID  ITM-ID      SHIP-QTY  UNIT-PRICE        AMT-SHIP
  ------  ----------  --------  ----------  --------------
   01008  C10000      0000002    00029.50          $59.00
          C10001      0000004    00021.00          $84.00
          C10002      0000006    00014.00          $84.00

Result

 =>
 Enter the sets attributes and press PF3 to save
 ------------------------------------------------------------------------DQA80
 DATAQUERY:  SAVE ACTIVE FOUND SET
 
 NAME: ________  DESCRIPTION: ____________________
 
 -----------------------------------------------------------------------------
 
 
 
 
 
 
 
 
 
 
 
 
 
 -----------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN         <PF3>  SAVE