Panels › (DQHU0) Secondary Table Selection

(DQHU0) Secondary Table Selection

 =>
  Press <PF4> if information from a secondary table is not desired
 --------------------------------------------------------------------------DQHU0
 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.
 
 Retrieve the first related record (bypass other occurrences)?   Yes _  No X
 -------------------------------------------------------------------------------
 SELECT|    TABLE NAME                    |STATUS|     DESCRIPTION
 -------------------------------------------------------------------------------
       |                                  |      |
       |                                  |      |
       |                                  |      |
       |                                  |      |
       |                                  |      |
       |                                  |      |
       |                                  |      |
       |                                  |      |
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN         <PF3> DISPLAY TEXT <PF4> CONTINUE
 <PF5> DISPLAY TABLE <PF6> DISPLAY QUERY  <PF7> BACKWARD     <PF8> FORWARD

Description

In the DQL Mode Guided Query Creation function, you can join your primary table (Primary Table Selection panel, DQH20) to a second table if they share a key or 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 DQH20 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>.

STATUS

Current database status of each table listed:

O

Open and ready for use.

C

Closed and cannot be used at this time.

D

Disabled and cannot be used.

DESCRIPTION

Description of each table, if any.

Entry Fields

Refer to the following for valid entries in the "Retrieve the first related row (bypass other occurrences)?" line. See the chapters on query syntax for more information about multiple occurrences.

Y

Place a character here and remove the X from NO if you want CA Dataquery to retrieve only the first related row when joining tables rather than all related rows to establish a relationship.

N

Leave X as the entry to indicate that CA Dataquery should retrieve all related rows in the secondary table to establish a relationship with the primary table.

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.