When you complete the last of the GUIDE panels, CA Dataquery presents the query it constructed according to your panel entries. The following is an example of how it appears:
Guided Query Display (DQIN0)
=> QUERY CREATION COMPLETED --------------------------------------------------------------------------DQIN0 DATAQUERY: GUIDED QUERY DISPLAY QUERY NAME: _______________ ------------------------------------------------------------------------------- TO EXECUTE THIS QUERY ONLINE, PRESS <PF3>. TO SUBMIT THIS QUERY FOR BATCH EXECUTION, PRESS <PF5>. TO EXIT GUIDED QUERY AND RETURN TO THE MAIN MENU, PRESS <PF4>. TO CONTINUE QUERY CREATION USING GUIDED QUERY, PRESS <PF6>. ------------------------------------------------------------------------------- ================================ T O P ====================================== 01 SELECT ITM_ID, SHIP_QTY, UNIT_PRICE, 02 SHIP-QTY * UNIT-PRICE 03 FROM CAI_SLSHST_TBL 04 ORDER BY ITM_ID ============================== B O T T O M ================================== ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXEC QUERY <PF4> MAIN MENU <PF5> SUBMIT QUERY <PF6> NEW QUERY <PF7> BACKWARD <PF8> FORWARD
Facts
The following chart explains how each line of the new query relates to the panels completed during operation of GUIDED QUERY CREATION: OPTION SELECTION
|
Line |
Keyword |
Panels and |
|---|---|---|
|
01/02 |
SELECT |
This clause tells which columns and results are to appear in the output row and the order in which they should appear. |
|
03 |
FROM |
This clause tells which table contains the data. |
|
04 |
ORDER BY |
This clause tells the sorting order for the report data. |
Steps
The following describes the steps for executing the newly created sample query.
Press <PF3> EXECUTE to display the execution panel.
Press <PF3> EXECUTE on the execution panel.
Options
During display of the ONLINE EXECUTION panel, you can display other panels to define the report format. See Getting a Report for details.
You can submit the query for batch execution. See Executing in Batch for details.
Type EDIT * on the command line to view the query on the EDITOR panel. You can then change it, make a business chart from the data it produces, or turn it into a dialog. See Creating Dialogs if you want to know more about editing the query.
Start up GUIDE again to make a new query by pressing <PF6> NEW QUERY.
Press <PF2> RETURN to return to one or more of this query's definition panels and make changes. Remember that when you return to a panel and then go forward again using <PF4> CONTINUE, you must redisplay every selection to retain it.
Display a directory and use <PF6> DELETE to delete the query. See Selecting a Directory for details.
|
Copyright © 2014 CA.
All rights reserved.
|
|