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

Step 2: Select First or Only Table

In this step, you learn how to tell CA Dataquery what database table to search and how many rows to locate in that table.

Concepts

These are the major concepts related to this step:

FIND
Tells CA Dataquery to search a database table. You can have only one FIND statement in a query.

(COUNT)
Tells CA Dataquery how many rows it must locate in the table. You can specify a number or ALL. The default is ALL if you do not specify anything.

Table-Name
Tells CA Dataquery the name of the table to search.

ROWS
Optional word used to clarify the statement.

Procedure

In the previous step, you learned how to identify the new query, by completing the fields at the top of the EDITOR panel. The following is a sample of how the panel looks now.

 =>

 --------------------------------------------------------------------------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 =====================================
 ..
 ..
 ..
 ..
 ..
 ..
 ..
 ..
 ..
 ..
 .. ===========================  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