=> Press <PF1> for help with defining the output row --------------------------------------------------------------------------DQII0 DATAQUERY: OUTPUT ROW: DEFINITION QUERY NAME: ------------------------------------------------------------------------------- Specify the order in which the columns are to appear in the output row by inserting an order number below. Column functions can be selected by placing any character in the corresponding fields. Count output rows? _ yes _ no ------------------------------------------------------------------------------- ORDER | TABLE NAME/ | | | | | COUNT NUMBER| COLUMN NAME | AVG | MAX | MIN | SUM | DISTINCT ------------------------------------------------------------------------------- | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Description
This SQL Mode Guided Query panel can be accepted with the defaults CA Dataquery assigns, resulting in report data printed in columns in the same order in which it was selected. However, you may want to change the order in which columns are printed. You may 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, you can obtain the results of the functions and specify a special legend to identify them on the report. See the CA Dataquery User Guide for a complete explanation of each available column function and an introduction to using this panel.
Action
Number the columns in the order wanted in the Order Number column. Enter any character in a column function column you want to perform on a particular column. Press Enter or <PF4> CONTINUE to go on to the next Guided Query panel.
Display Fields
Refer to the following for explanations of the display fields intended to contain variable data.
Name assigned the query you are defining.
Columns
Refer to the following for a discussion of each column on this panel.
Numbers appearing in this column are assigned automatically by CA Dataquery. Change the numbers as needed by typing over the current number to indicate the order of columns on the report.
Datadictionary names of the columns you selected for use, including table names.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce an average at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce the maximum amount found at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce the minimum amount found at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce a total at the end of the report.
Enter a character in this column next to any column or key for which you want CA Dataquery to produce a count of the data items in this column at the end of the report.
PF Keys
The following lists the PF keys for this panel, with a brief description of each function.
Displays Help information about the current panel.
Exits (DQHG0) panel.
Displays the next Guided Query panel when this one is complete. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)
Displays the extended column definition for key/column selected by cursor.
Displays the query created so far.
Displays a previous panel, if any.
Displays next panel, if any.
|
Copyright © 2014 CA.
All rights reserved.
|
|