Panels › (DQIU0) Grouping Rows: Priority

(DQIU0) Grouping Rows: Priority

 =>
 
 --------------------------------------------------------------------------DQIU0
 DATAQUERY: GROUPING ROWS: PRIORITY            QUERY NAME:
 ------------------------------------------------------------------------------
 If you have more than 1 column on which grouping will occur, number them
 1, 2, and so on, to show their grouping priority from major to minor.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 PRIORITY| TABLE NAME/                       |
 NUMBER  |  COLUMN NAME                      | DESCRIPTION
 -------------------------------------------------------------------------------
         |                                   |
         |                                   |
         |                                   |
         |                                   |
         |                                   |
         |                                   |
         |                                   |
         |                                   |
         |                                   |
 -------------------------------------------------------------------------------
 <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 displays the columns on which grouping will occur. You selected both columns and functions for your output, so the columns will be used to group the retrieved rows for the column function calculations you requested.

Action

On this panel, prioritize the columns that will be used to group the rows. You can type over the default priorities with numeric values. Press <PF4> CONTINUE or Enter to go to the next panel.

Display Fields

Refer to the following chart for explanations of the display fields intended to contain variable data.

QUERY NAME:

Name of the query you are creating.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Columns

Refer to the following for a discussion of each column on this panel.

TABLE NAME/ COLUMN NAME

Identifies a grouping column.

DESCRIPTION

Datadictionary description assigned to column name.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Exits the current panel.

<PF4> CONTINUE

Displays the next Guided Query panel.

<PF5> EXTEND COLUMN

Shows definition of column selected by cursor.

<PF6> DISPLAY QUERY

Displays query created so far.

<PF7> BACKWARD

Scrolls list backward one page.

<PF8> FORWARD

Scrolls list forward one page.