DQHG0
=> --------------------------------------------------------------------------DQHG0 DATAQUERY: REPORT COLUMN DEFINITION QUERY NAME USER-SAMPLE ------------------------------------------------------------------------------- Select the keys or columns to be columns on the report by placing any character next to the desired names. ------------------------------------------------------------------------------- SELECT|TABLE/KEY(*) OR COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- | CAI-DETAIL-TBL | _ | * ITM-ID-KEY | DETAILS ITEM-ID SECONDAY KEY _ | * CUST-ID | CUSTOMER ID _ | * ITMID-ORDID-KEY | ITMID & ORDID SECONDARY KEY _ | * ITM-ID | ITEM ID _ | * ORDID-ITMID-KEY | DETAIL ORDID & ITMID KEY _ | SHIP-QTY | QUANTITY SHIPPED _ | UNIT-PRICE | UNIT PRICE _ | * TEMPORARY RESULT | _ | SHIP-PRICE | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Purpose
The required REPORT COLUMN DEFINITION QUERY NAME panel allows you to choose up to 96 of the keys and columns of the tables you selected for your query to be printed in your report.
Important If you plan to create your own titles and reformat numeric data in a later step, your query could become quite lengthy and exceed the line limit of the EDITOR panel established at your site.
Your site may have established a limit of 24, 48, 72, or 96 lines. For details, contact your CA Dataquery Administrator. (If you have displayed your query with each step, you have an idea of how many lines it occupies.) The contents of each key, column or temporary result selected can be printed on the report.
Concepts
These are the major concepts related to this panel:
Key
Remember that keys can be made up of more than one column. You might not want a key printed on your report.
Column
You should make at least one selection to complete your query and obtain results. Otherwise, all your query does is read a table, make calculations, and sort data, and you would never see the results.
Panel Operation
On this panel, you use the Tab key to move the cursor from one field to another, mark a character in the blank next to the column or key you want to report, and press <PF4> CONTINUE to display the next panel.
Completed Example
The following completed panel shows how to use the REPORT COLUMN DEFINITION QUERY NAME panel to select columns whose data will appear in your report.
=> --------------------------------------------------------------------------DQHG0 DATAQUERY: REPORT COLUMN DEFINITION QUERY NAME USER-SAMPLE ------------------------------------------------------------------------------- Select the keys or columns to be columns on the report by placing any character next to the desired names. ------------------------------------------------------------------------------- SELECT|TABLE/KEY(*) OR COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- | CAI-DETAIL-TBL | _ | * ITM-ID-KEY | DETAILS ITEM-ID SECONDAY KEY X | * CUST-ID | CUSTOMER ID _ | * ITMID-ORDID-KEY | ITMID & ORDID SECONDARY KEY X | * ITM-ID | ITEM ID _ | * ORDID-ITMID-KEY | DETAIL ORDID & ITMID KEY X | SHIP-QTY | QUANTITY SHIPPED X | UNIT-PRICE | UNIT PRICE | * TEMPORARY RESULT | X | SHIP-PRICE | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
The following explains each entry/selection.
To know which customer's data is presented.
To know which items were ordered.
To know how many ordered items were shipped.
To show the price for each individual item.
To show the results of the calculation.
Options
You could print all columns in the report, or only one. Whatever data you need can be included in this report.
To Go to the Next Step
After selecting columns for the report, tell CA Dataquery the order in which to print them, and any mathematical functions or column titles to use. Pressing <PF4> CONTINUE displays the next panel.
|
Copyright © 2014 CA.
All rights reserved.
|
|