Panels › (DQIE0) Ordering Rows: PRIORITY

(DQIE0) Ordering Rows: PRIORITY

 =>
 
 --------------------------------------------------------------------------DQIE0
 DATAQUERY: ORDERING ROWS: PRIORITY            QUERY NAME:
 ------------------------------------------------------------------------------
 Determine the order in which your output rows will be returned to you by
 entering 1, 2, and so on, as a priority number next to any column you wish
 to use in determining output sequence.  Sequence ascending or sequence
 descending can be selected by placing any character under the sequence
 abbreviation.
 -------------------------------------------------------------------------------
 PRIORITY|TABLE NAME/                        |SEQUENCE|
 NUMBER  | COLUMN NAME                       |ASC/DESC| 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 allows you to select and order rows in ascending and descending sequence for presentation.

Action

Prioritize columns or expressions by entering a number from 1 to 10 in the Priority Number field preceding each column or expression name.

Display Fields

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

QUERY NAME:

The name you assigned this query.

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

Names of the columns you selected for use, including table names.

DESCRIPTION

Datadictionary description of each column you selected for use in structuring your calculation.

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

Returns to Sort Criteria Definition (DQHD0) panel.

<PF4> CONTINUE

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.)

<PF5> EXTEND COLUMN

Displays the extended column definition for key/column selected by cursor.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.