Panels › (DQI60) Search Conditions: Designate Columns

(DQI60) Search Conditions: Designate Columns

 =>
  Press <PF4> if you do not wish to specify further selection conditions
 --------------------------------------------------------------------------DQI60
 DATAQUERY: SEARCH CONDITIONS: DESIGNATE COLUMNS    QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Specify columns that will be evaluated for row selection by placing
 any character next to the desired names.
 -------------------------------------------------------------------------------
 SELECT| TABLE/COLUMN NAME                  |  DESCRIPTION
 -------------------------------------------------------------------------------
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

The SQL Mode Guided Query optional Search Conditions: 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.

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

TABLE/ COLUMN NAME

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

DESCRIPTION

Description, if any, of each 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.