Using CREATE in DQL Mode › Creating the Sample Query › Step 2: Select First or Only Table › Copy the FIND Statement

Copy the FIND Statement

To copy the FIND statement, follow these steps:

1. Enter 1 in the space before the FIND statement format.
2. Press <PF2> RETURN to return to the CREATE MODE panel.

Entering 1 indicates a need for only one FIND statement in the query. A query cannot have more than one FIND verb, so if you enter 2 or a larger number, the CA Dataquery EDITOR places only one FIND statement on the CREATE MODE panel. Pressing <PF2> RETURN returns to the CREATE MODE panel. When this panel is redisplayed, the FIND statement appears at the cursor location.

 =>

 --------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR            CURRENT TABLE:  ________________________________
 -------------------------------------------------------------------------------
 NAME:          USER-SAMPLE                       TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   TOTAL ORDERS PER CUSTOMER -- AVERAGE PRICE
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01  FIND (count)  table-name    ROWS
 .. ===========================  B O T T O M  ==================================









 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN      <PF3>  DISPLAY COLUMNS <PF4> DISPLAY KEYS
 <PF5> DISPLAY ALL  <PF6>  LIST TABLES <PF7> BACKWARD         <PF8>  FORWARD
 <PF9> TEMPLATE     <PF10> VALIDATE    <PF11> RIGHT/LEFT      <PF12> PROCESS MODE