Panels › (DQHT0) Primary Table Selection

(DQHT0) Primary Table Selection

=>
 
--------------------------------------------------------------------------DQHT0
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                    |STATUS|     DESCRIPTION
-------------------------------------------------------------------------------
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
   _  |                                  |      |
-------------------------------------------------------------------------------
<PF1> HELP          <PF2> RETURN         <PF3> DISPLAY TEXT <PF4> CONTINUE
<PF5> DISPLAY TABLE <PF6> DISPLAY QUERY  <PF7> BACKWARD     <PF8> FORWARD

Description

In DQL Mode, the 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. CA Dataquery reads the primary table in its search. It should contain all of the data you want if it is to be the only table read. An introduction to using this panel appears in the CA Dataquery User Guide.

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 for explanations of the display field intended to contain variable data.

QUERY NAME:

Name you assigned the query.

Entry Fields

Refer to the following for valid entries in the field 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.

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.

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.