Panels › (DQH60) Selection Criteria: Designate Columns

(DQH60) Selection Criteria: Designate Columns

 =>
 Press <PF4> if you do not wish to specify further selection conditions
 --------------------------------------------------------------------------DQH60
 DATAQUERY: SELECTION CRITERIA: DESIGNATE COLUMNS   QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Specify columns that will be evaluated for record selection by placing
 any character next to the desired names.
 -------------------------------------------------------------------------------
 SELECT| KEY(*) AND COLUMN NAMES            |  DESCRIPTION
 -------------------------------------------------------------------------------
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, the optional Guided Query Selection Criteria: Designate Columns panel allows you to begin narrowing the query's search for data. You can select up to 15 columns that contain data for which you can search, by stating that you want to see a range of data, an exact match, and so forth. You use this panel to begin specifying search criteria that tell CA Dataquery to read only rows that contain data you specify. You begin defining the selection criteria by naming the columns with this panel.

For instance, you can indicate that you only want rows that contain specific values in a particular column, like CITY = DALLAS. With this panel you would select CITY and on a following panel you would specify that CITY should contain DALLAS for a row to be selected. An introduction to using this panel appears in the CA Dataquery User Guide.

Action

Enter a character in the Select column next to any columns you want to use in specifying selection criteria for this query. Then press Enter or <PF4> CONTINUE to go to the next panel.

Display Fields

Refer to the following for explanations of the display field intended to contain variable data.

QUERY NAME:

Name you assigned this query.

Columns

Refer to the following for a discussion of each column on this panel.

SELECT

Place a character next to the names of any columns for which you want to specify qualifying values.

KEY(*) AND COLUMN NAMES

Lists the names of all keys and columns in the tables you selected for this query. If two tables were selected, the primary table keys and columns are listed first, followed by the secondary keys and columns. Scroll forward to see additional panels if the list extends beyond the current panel.

DESCRIPTION

Description, if any, of each key and column listed.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to the Primary Table Selection (DQH20) panel.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF5> EXTEND COLUMN

Displays the extended column/definition for key/column selected by cursor position.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.