Previous Topic: Copy the FIND StatementNext Topic: Select the Table Name

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

Edit the FIND Statement

In the above panel, the FIND statement format is displayed exactly as it appeared on the TEMPLATE panel. The format must be edited to complete the FIND statement for this query.

Steps for the above panel are:

  1. Type ALL over (count) to indicate the query is going to search all rows in the table.
  2. Use the DELETE key to remove extraneous characters and spaces between ALL and ROWS. (There are three spaces between these words.)
  3. Place the cursor between ALL and ROWS to indicate where the table name is to be inserted.
  4. Pressing <PF6> LIST TABLES displays a list of authorized tables.

Typing ALL means the query searches all rows in the table. The data can still be limited by specifying selection criteria. (See Step 3: Specify Conditions for details on how to specify these conditions.)

CA Dataquery ignores extra spaces in a statement.