=> --------------------------------------------------------------------------DQHE0 DATAQUERY: ROW ORDERING QUERY NAME: ------------------------------------------------------------------------------ If you chose more than 1 sort column, number them 1, 2, etc. to show their sort priority from major to minor. Defaults are provided and can be modified. Sort sequence, control breaks, and paging control may be selected by placing any character in the corresponding columns. ------------------------------------------------------------------------------- ORDER | TABLE NAME/ |SORT SEQUENCE |CONTROL | NEW NUMBER| KEY OR COLUMN NAME |ASCEND/DESCEND| BREAK | PAGE ------------------------------------------------------------------------------- | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD
Description
In DQL Mode, the Guided Query Row Ordering panel appears when you select a sort column. On it are listed the columns selected in the order in which they were listed on the previous panel. Their order on the Row Ordering panel indicates sorting priority from major to minor. You can change the priority.
This panel also allows you to specify whether you want to sort from lowest to highest or highest to lowest value. Especially important, this panel lets you name the sort columns, allow control breaks, and start a new report page for each logical group created by sorting. An introduction to this panel appears in the CA Dataquery User Guide.
Action
Accept the default sorting order or change the numbers to reflect the sorting priority for columns you selected with the previous panel. Indicate ascending or descending order for each column and, if you want a control break taken when the values change for any column, enter a character in the control break column for the columns.
If you want the output to begin a new page when the value in a sort column changes, place a character in the New Page column next to the column name. Press Enter or <PF4> CONTINUE to go on.
Display Fields
Refer to the following for explanations of the display fields intended to contain variable data.
The name you assigned this query.
Columns
Refer to the following for a discussion of each column on this panel.
Enter a new number in this column for one or more columns.
Names of columns or keys selected as sort columns and their table names.
For each column/key name, place a character in the ASCEND/ column under ascend if you want to sort from lowest to highest, under descend if you want to sort from highest to lowest.
For each column/key name, place a character in this column if you want totaling or calculations to be performed when the value (contents) of a column changes.
For each column/key name, place a character in this column if you want the report to begin a new page when the contents of the column/key changes.
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.
Returns to Sort Criteria Definition (DQHD0) 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.
|
|