=> --------------------------------------------------------------------------DQHJ0 DATAQUERY: FUNCTION CONTROL BREAK SELECTION QUERY NAME: _______________ ------------------------------------------------------------------------------- Select the control break level at which the _______ column function for the ________________________________ column in the ________________________________ table is to be displayed. The appropriate level may be indicated by placing any character next to the desired names. ------------------------------------------------------------------------------- SEL|LEVEL| CONTROL BREAK COLUMN NAME | CONTROL BREAK COLUMN DESCRIPTION ------------------------------------------------------------------------------- | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> NOT USED <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Description
In DQL Mode, the optional Guided Query Function Control Break Selection panel allows you to tell CA Dataquery when to print the results of a function (shown on panel) you selected for the column named on this panel.
One Function Control Break Selection panel appears for each function selected for each column. You can choose to produce function results at each control break (when the value in the column changes) or you can accept the default and print the result at the end of the report.
If you specified more than one sort column with the SORT CRITERIA DEFINITION (DQHD0) panel, and assigned control breaks to those columns with the ROW ORDERING (DQHE0) panel, each has a level or priority that appears on this panel. End of report priority is 000. You select the control breaks at which you want this function performed.
Action
Choose one or more control breaks or end of report and press ENTER or <PF4> CONTINUE to go on to the next Guided Query panel.
Display Fields
Refer to the following chart for explanations of the display fields intended to contain variable data.
Name you assigned this query.
Function selected for this column on the Column Definition panel (DQHI0). Can be AVG, MAX, MIN, SUM or CNT.
Name of the column/key to which this column function was designated for production at control break or end of report.
Name of the database table containing the column/key for this column function.
Columns
Refer to the following for a discussion of each column on this panel.
Place a character next to the levels at which you want the current column function performed.
You assigned a sort priority on the Row Ordering (DQHE0) panel for each sort column you selected for this query. Each has a priority number or level with 001 indicating the major sort column. Level 000 is assigned to the end of the report.
This column lists the table and column name for each sort column you selected for this query.
The Datadictionary description, if any, attached to the column listed at the left. Also lists the END OF REPORT notation for the 000 level selection option.
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 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 query created so far.
Displays a previous panel, if any.
Displays next panel, if any.
|
Copyright © 2014 CA.
All rights reserved.
|
|