DQH20
=> --------------------------------------------------------------------------DQH20 DATAQUERY: PRIMARY TABLE SELECTION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------- _ | ADDRESS | O | CUSTOMER ADDRESSES _ | CAI-ACCTS-TBL | O | ORDER ENTRY DEMO ACCTS ROW _ | CAI-CUST-TBL | O | CUSTOMERS ROW _ | CAI-DETAIL-TBL | O | DETAILS ROW _ | CAI-ITEMS-TBL | O | ITEMS ROW _ | CAI-ORD-NO-TBL | O | ORDER NUMBERS ROW _ | CAI-ORDERS-TBL | O | ORDERS ROW _ | CAI-RCPTS-TBL | O | ORDER ENTRY DEMO RECEIPTS REC _ | CAI-SHIPTO-TBL | O | SHIP-TO ROW _ | CAI-SLSHST-TBL | O | ORDER ENTRY DEMO SALES-HIST R _ | CAIDEMO-DEM-PNC | O | CAI SAMPLE PART COST TABLE ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISPLAY TEXT <PF4> CONTINUE <PF5> DISPLAY TABLE <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
If you are not certain how to complete a panel, you can press <PF1> HELP to get some information about the panel. Then you decide how you want to complete it.
Purpose
The required PRIMARY TABLE SELECTION panel tells CA Dataquery which table to read for the data you want.
Concepts
These are the major concepts related to this panel:
Primary Table
The primary table should contain all of the data you want if it is to be the only table read. If you plan to join two tables, CA Dataquery reads the primary table first and then looks for rows in the secondary table that meet criteria specified in the query for joining the rows from each table to make the rows in the active found set.
Table Names
The table names shown on this panel are entity-names assigned by CA Datacom Datadictionary. The names listed are all the tables you can access, including your personal tables.
Secondary Table
If you want CA Dataquery to join the primary table to another database table (the secondary table), the primary table should share a common value with the secondary table. If CA Dataquery finds a row in the primary table, it searches the secondary table for matching data. You can press <PF5> DISPLAY TABLE to see a list of keys and columns for the table selected by the cursor. Use this list to plan ahead.
Status
A database table can be open (O), closed (C), or disabled (D). If it is closed or disabled, CA Dataquery cannot read it and you cannot select it at this time. Contact your CA Dataquery Administrator if you need access to a table which is closed or disabled.
Panel Operation
On this panel, you use the Tab key to move the cursor from one blank field to another. Locate the cursor next to the table you want to select and enter a character. Press <PF4> CONTINUE (or Enter) to display the next panel.
Note: For complete instructions on operating this panel, see the CA Dataquery Reference Guide.
Completed Example
The following completed panel shows the completed PRIMARY TABLE SELECTION panel that specifies the table CA Dataquery is to read.
=> --------------------------------------------------------------------------DQHT0 DATAQUERY: PRIMARY TABLE SELECTION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------- _ | ADDRESS | O | _ | CAI-ACCTS-TBL | O | ORDER ENTRY DEMO ACCTS ROW _ | CAI-CUST-TBL | O | CUSTOMERS ROW x | CAI-DETAIL-TBL | O | DETAILS ROW _ | CAI-ITEMS-TBL | O | ITEMS ROW _ | CAI-ORD-NO-TBL | O | ORDER NUMBERS ROW _ | CAI-ORDERS-TBL | O | ORDERS ROW _ | CAI-RCPTS-TBL | O | ORDER ENTRY DEMO RECEIPTS REC _ | CAI-SHIPTO-TBL | O | SHIP-TO ROW _ | CAI-SLSHST-TBL | O | ORDER ENTRY DEMO SALES-HIST R _ | CAIDEMO-DEM-PNC | O | CAI SAMPLE PART COST TABLE ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISPLAY TEXT <PF4> CONTINUE <PF5> DISPLAY TABLE <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
This chart explains each entry/selection.
|
Field or Item |
Sample Entry |
Reason |
|---|---|---|
|
CAI-DETAIL-TBL |
X |
A displayed list of key and column names and the displayed CA Datacom Datadictionary text description of each column shows that this table contains all of our data. |
Options
You could use the PRIMARY TABLE SELECTION panel to display columns and keys for any table, changing your selection until you found the one you wanted. If you need data that is in another table, you could join your primary table to another, secondary table, by making a selection from the SECONDARY TABLE SELECTION panel, and report on data that is contained in both tables.
Note: For more information about joining tables, see the CA Dataquery Reference Guide.
To Go to the Next Step
When the PRIMARY TABLE SELECTION panel is complete, CA Dataquery displays an unneeded panel because the selections on the initial GUIDE panel cause all panels to appear. Following is an example of how it appears:
=> PRESS <PF4> IF INFORMATION FROM A SECONDARY TABLE IS NOT DESIRED --------------------------------------------------------------------------DQHU0 DATAQUERY: SECONDARY TABLE SELECTION QUERY NAME: USER-SAMPLE____ ------------------------------------------------------------------------------- YOU CAN USE INFORMATION FROM THE PRIMARY TABLE CAI-DETAIL-TBL_________________ 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 ROW (BYPASS OTHER OCCURRENCES)? YES _ NO X START WITH: __________________________________ ------------------------------------------------------------------------------- SELECT| TABLE NAME |STATUS| DESCRIPTION ------------------------------------------------------------------------------- | | |
The following chart tells you which panels are skipped and why.
Note: For detailed information about the panels, see the CA Dataquery Reference Guide.
|
Panel Name |
What It Does |
Reason Skipped |
|---|---|---|
|
SECONDARY TABLE SELECTION (DQH30) |
Lists other tables that can be joined to yours for the search. |
All data is in the primary table. |
|
PRIMARY TABLE KEY SELECTION (DQH40) |
Lists keys and |
Does not appear when secondary table is not selected. |
|
SECONDARY TABLE KEY SELECTION (DQH50) |
List keys and columns shared. |
Do not appear when secondary table is not selected. |
Summary
You can select the database table, that CA Dataquery is to search, for your data. You can determine whether it contains the data needed by displaying the list of columns and keys and then displaying the CA Datacom Datadictionary description for each column.
When the SELECTION CRITERIA: DESIGNATE COLUMNS panel appears, pressing <PF6> DISPLAY QUERY displays the following:
=> --------------------------------------------------------------------------DQHN0 DATAQUERY: GUIDED QUERY DISPLAY QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- ================================ T O P ====================================== FIND ALL CAI-DETAIL-TBL ============================== B O T T O M ================================== ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> NOT USED <PF5> NOT USED <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD
So far, the query has a name and library. It will read (FIND) all of the CAI-DETAIL-TBL rows in your search for data.
|
Copyright © 2014 CA.
All rights reserved.
|
|