(DQM20) Primary Table Selection

Panels › (DQM20) Primary Table Selection

(DQM20) Primary Table Selection

=>
 
--------------------------------------------------------------------------DQM20
DATAQUERY:  PRIMARY TABLE SELECTION              QUERY NAME:  _______________
-------------------------------------------------------------------------------
Select one table from which you want information by placing any character
next to the desired table name.  START WITH  ________________________________
-------------------------------------------------------------------------------
SELECT|   TABLE NAME                     | DESCRIPTION
-------------------------------------------------------------------------------
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
   _  |                                  |
-------------------------------------------------------------------------------
<PF1> HELP          <PF2> RETURN         <PF3> DISPLAY TEXT <PF4> CONTINUE
<PF5> DISPLAY TABLE <PF6> DISPLAY QUERY  <PF7> BACKWARD     <PF8> FORWARD

Description

The SQL Mode Guided Query Creation function required Primary Table Selection panel tells CA Dataquery which table to search (first if you want to search two tables) for the data you want. The primary table is the one CA Dataquery will read in its search. It should contain all of the data you want if it is to be the only table read.

Action

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

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Field	Required?	Valid Entries	Default
QUERY NAME:	N	Any unique name	None
START WITH	N	Any unique characters	None

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 primary table you want your query to search.
TABLE NAME: Lists all database tables you are authorized to access. Lists 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 the text description of a table selected by cursor position.
<PF4> CONTINUE: Displays the next panel and saves this selection. (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.