Panels › (DQM30) Secondary Table Selection

(DQM30) Secondary Table Selection

 =>
  Press <PF4> if information from a secondary table is not desired
 --------------------------------------------------------------------------DQM30
 DATAQUERY:  SECONDARY TABLE SELECTION            QUERY NAME:  _______________
 -------------------------------------------------------------------------------
 You can use information from the primary table _______________________________
 to join with related information from another table. To join two tables,
 select the second table by placing any character next to the desired name.
 -------------------------------------------------------------------------------
 SELECT|    TABLE NAME                    | DESCRIPTION
 -------------------------------------------------------------------------------
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
       |                                  |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN         <PF3> DISPLAY TEXT <PF4> CONTINUE
 <PF5> DISPLAY TABLE <PF6> DISPLAY QUERY  <PF7> BACKWARD     <PF8> FORWARD

Description

In the SQL Mode Guided Query Creation function, you can join your primary table (Primary Table Selection panel, H20) to a second table if they share a column. Then you can report on data that is contained in both tables. Use this panel to select an optional secondary table for joining.

Action

Place a character next to the name of the table you want the query to search and then press Enter or <PF4> CONTINUE.

Display Fields

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

QUERY NAME:

Name you assigned the query.

primary table

Table selected first with panel DQI20 as the primary search table.

Columns

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

SELECT

Place a character next to one database table name to select the secondary table you want your query to search.

TABLE NAME

Lists all database tables you are authorized to access. List can be continued on additional panels that you can display by scrolling forward with <PF8>.

DESCRIPTION

Description of each table, if any.

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

Exits panel.

<PF3> DISPLAY TEXT

Displays text description, if it exists, of a table selected by cursor position.

<PF4> CONTINUE

Displays the next panel. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF5> DISPLAY TABLE

Displays the keys and columns for the table selected by cursor position.

<PF6> DISPLAY QUERY

Displays the query so far.

<PF7> BACKWARD

Scrolls back to see previous panels of multi-screen panel.

<PF8> FORWARD

Scrolls forward to see next panel, if a multi-screen panel.