DQHA0
=> --------------------------------------------------------------------------DQHA0 DATAQUERY: SELECT COLUMNS FOR CALCULATION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- Select the columns you wish to use in calculating the value of the temporary result. SHIP-PRICE with precision (13.2). Place any character next to the desired names. ------------------------------------------------------------------------------- SELECT| TABLE NAME/COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- | CAI-DETAIL-TBL | _ | CUST-ID | _ | ORD-QTY | _ | SHIP-QTY | _ | UNIT-PRICE | _ | DISC-PCT | | | | | | | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Purpose
You will not need to fill out this panel if your temporary result is to be set to a specific value. For example, INTEREST = 8.25. You do fill out this panel if columns from the selected database tables are used in calculating the value of your temporary result. You only use it if your arithmetic expression will include data found during query execution in a column. With it, you tell CA Dataquery which columns you will use in an arithmetic expression to create the results you want. You can use up to ten columns. You are also allowed to include literal values in your calculation.
Concepts
These are the major concepts related to this panel:
Columns for Calculation
All columns listed on this panel are numeric. However, you should be aware of the definition of any column you use in a calculation.
Calculation
You will be permitted on the following panel to type an algebraic equation or use the default equation provided. Your equation can be as simple or as complex as you need it to be.
Panel Operation
You use the Tab key to move the cursor from one field to another, select columns by marking a character next to their names, and press <PF4> CONTINUE to display the next panel. If the list of columns extends beyond the screen, you can use the PF keys to scroll forward and backward.
Completed Example
The following completed panel shows how to select the columns for the calculation to be defined.
=> --------------------------------------------------------------------------DQHA0 DATAQUERY: SELECT COLUMNS FOR CALCULATION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- Select the columns you wish to use in calculating the value of the temporary result. SHIP-PRICE with precision (13.2). Place any character next to the desired names. ------------------------------------------------------------------------------- SELECT| TABLE NAME/COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- | CAI-DETAIL-TBL | _ | CUST-ID | _ | ORD-QTY | X | SHIP-QTY | X | UNIT-PRICE | _ | DISC-PCT | | | | | | | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
This chart explains each entry/selection.
|
Field or Item |
Sample Entry |
Reason |
|---|---|---|
|
SHIP-QTY |
X |
To get the number of items shipped. |
|
UNIT-PRICE |
X |
To get the price per item. |
Options
You could select only one column to be calculated using a constant number or you could select more columns. Or, you could skip this panel altogether, and go on to define a calculation whose results would appear on the report for every output row.
To Go to the Next Step
After the columns for calculation are selected, press <PF4> CONTINUE to display the next panel.
|
Copyright © 2014 CA.
All rights reserved.
|
|