Panels › (DQH40) Primary Table: Key Selection

(DQH40) Primary Table: Key Selection

 =>
 
 --------------------------------------------------------------------------DQH40
 DATAQUERY:  PRIMARY TABLE:  KEY SELECTION         QUERY NAME: _______________
 -------------------------------------------------------------------------------
 The primary table _______________________________ can be joined with the
 secondary table ________________________________ by matching identical values
 for a key or column appearing in both tables. Select the key or column to be
 used from the primary table by placing any character next to its name.
 -------------------------------------------------------------------------------
 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, you must complete this Guided Query panel if you selected a primary table and a secondary table for your query. The panel displays a list of keys and columns from which you can choose one that will contain a value that will match a value in a key or column of the secondary table. These matching values will join rows from each table for the query's search for data.

Action

Type a character in the Select column next to the name of the key or column to be used for joining with the secondary table, key or column.

Display Fields

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

QUERY NAME:

The name you assigned this query.

primary table_

The table you selected first.

secondary table_

The table you selected for CA Dataquery to read second.

Columns

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

SELECT

Place a character next to the name of a key or column in the primary table whose values will match values in a key or column you will choose for the secondary table.

KEY(*) AND COLUMN NAMES

Keys and columns in the primary table. Scroll forward if list extends beyond the current panel.

DESCRIPTION

Description, if any, for each key and column.

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