DQHI0
=> Press <PF1> for help with defining the report --------------------------------------------------------------------------DQHI0 DATAQUERY: COLUMN DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- Specify the order in which the columns are to appear on the report by inserting an order number below. Column functions may be selected by placing any character in the corresponding input field. ------------------------------------------------------------------------------- ORDER | TABLE NAME/ | | | | | | NUMBER| KEY OR COLUMN NAME | AVG | MAX | MIN | SUM | CNT | TOT ------------------------------------------------------------------------------- |CAI-DETAIL-TBL | | | | | | 01 | CUST-ID | | | | | | 02 | ITM-ID | | | | | | 03 | SHIP-QTY | | | | | | 04 | UNIT-PRICE | | | | | | |TEMPORARY RESULT | | | | | | 05 | SHIP-PRICE | | | | | | | | | | | | | | | | | | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Purpose
The COLUMN DEFINITION panel can be accepted with the defaults CA Dataquery assigns, resulting in report data printed in the same order in which it was selected. However, you might want to change the order in which columns are printed. You might also want to request that mathematical functions be performed on some or all numeric columns. If so, you will select math functions for columns. At the end of the report, or at control breaks that you can specify later, you can obtain the results of the functions which you select on this panel.
Concepts
These are the major concepts related to this panel:
Column Functions
You may enhance the contents of your report by applying mathematical functions to individual columns. You can print the results of performing these functions on your report in either or both of two locations. You can print results at control breaks and at the end of the report.
Mathematical Functions
The following mathematical functions are available to you:
CA Dataquery divides the number of rows reported into the total of the selected column to obtain an average.
CA Dataquery reports the largest value found for the specified column.
CA Dataquery reports the smallest value found for the specified column.
CA Dataquery reports the total of all values for the specified column.
CA Dataquery reports the number of rows found.
CA Dataquery reports totals in column format at all control breaks and at the end of the report.
These totals print in the columns of the column totaled.
Panel Operation
On this panel, the Tab key moves the cursor from one field to another. You type entries, and press <PF4> CONTINUE to display the next panel.
Completed Example
The following completed COLUMN DEFINITION panel shows how to prepare the sample report and perform mathematical functions.
=> Press <PF1> for help with defining the report --------------------------------------------------------------------------DQHI0 DATAQUERY: COLUMN DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- Specify the order in which the columns are to appear on the report by inserting an order number below. Column functions may be selected by placing any character in the corresponding columns. ------------------------------------------------------------------------------- ORDER | TABLE NAME/ | | | | | | NUMBER| KEY OR COLUMN NAME | AVG | MAX | MIN | SUM | CNT | TOT ------------------------------------------------------------------------------- |CAI-DETAIL-TBL | | | | | | 01 | CUST-ID | | | | | | 02 | ITM-ID | | | | | | 03 | SHIP-QTY | | | | | | 04 | UNIT-PRICE | | | | | | |TEMPORARY RESULT | | | | | | 05 | SHIP-PRICE | X | | | | | X | | | | | | | - 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/Item |
Sample Entry |
Reason |
|---|---|---|
|
Order |
Accepted defaults |
The defaults happened to match the order in which the data should appear. |
|
SHIP-PRICE |
AVG |
To show how much, on the average, this customer is willing to spend. |
|
SHIP-PRICE |
TOT |
To show totals for each customer. |
Options
It is possible to select a different column function for each numeric column in the report. AVG, MIN, MAX, TOT, and SUM are for numeric columns only. CNT can be selected for any column.
Note: For more information about column functions, see the CA Dataquery Reference Guide.
To Go to the Next Step
The next step is to refine the report's appearance. This example skips the next panel that appears. It allows assigning titles to the report columns. Skipping this panel causes CA Dataquery to use CA Datacom Datadictionary default column headings. If there are no default column headings, CA Dataquery uses the column names. This example also skips the next panel, REPORT COLUMN FORMAT DEFINITION, since the defaults are acceptable.
Following are samples of the two panels to be skipped.
=> --------------------------------------------------------------------------DQHK0 DATAQUERY: REPORT COLUMN HEADING DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- You may enter alternate headings for any column on the report. Defaults are provided and can be modified. ------------------------------------------------------------------------------- COLUMN: ITM-ID LINE1: ITM-ID TABLE : CAI-DETAIL-TBL LINE2: COLUMN: SHIP-QTY LINE1: SHIP-QTY TABLE : CAI-DETAIL-TBL LINE2: COLUMN: UNIT-PRICE LINE1: UNIT-PRICE TABLE : CAI-DETAIL-TBL LINE2: COLUMN: ORD-ID LINE1: ORD-ID TABLE : CAI-DETAIL-TBL LINE2: ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
=> --------------------------------------------------------------------------DQHL0 DATAQUERY: REPORT COLUMN FORMAT DEFINITION QUERY NAME: USER-SAMPLE ------------------------------------------------------------------------------- Select the type of editing desired for each numeric column on your report. Place any character in the column that represents the edit format needed. Defaults are provided and can be modified. Column 1: 12345.678 Column 3: 0,012,345.678 Column 5: Datadictionary edit Column 2: 12,345.678 Column 4: $12,345.68 ------------------------------------------------------------------------------- TABLE NAME/COLUMN NAME | 1 | 2 | 3 | 4 | 5 ------------------------------------------------------------------------------- CAI-DETAIL-TBL | | | | | SHIP-QTY | _ | X | _ | _ | UNIT-PRICE | _ | X | _ | _ | ORD-ID | _ | X | _ | _ | TEMPORARY RESULT COLUMN | | | | | SHIP-PRICE | _ | X | _ | _ | | | | | | | | | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
The following chart describes the panels to be skipped. For detailed information about these panels, please see the CA Dataquery Reference Guide.
|
Panel Name |
What It Does |
Reason for Omission |
|---|---|---|
|
Report Column Heading |
Applies new titles |
The defaults are acceptable. |
|
Report Column Format |
Allows you to tell CA Dataquery how to |
The default is acceptable:
|
|
Copyright © 2014 CA.
All rights reserved.
|
|