Panels › (DQHD0) SORT Criteria Definition

(DQHD0) SORT Criteria Definition

 =>
 Press <PF4> if you do not wish to define sort criteria
 --------------------------------------------------------------------------DQHD0
 DATAQUERY:  SORT CRITERIA DEFINITION          QUERY NAME:
 -------------------------------------------------------------------------------
 You may order the selected rows in ascending or descending sequence
 according to the contents of one or more columns.  Select the columns by
 placing any character next to the desired names.
 -------------------------------------------------------------------------------
 SELECT | TABLE NAME/KEY (*) OR COLUMN NAME      |     DESCRIPTION
 -------------------------------------------------------------------------------
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
        |                                        |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, the optional Guided Query Sort Criteria Definition panel allows you to order rows in your report in ascending or descending sequence according to the contents of one or more database or temporary results. With this capability, you can group rows together for purposes of reporting. Please see the CA Dataquery User Guide for an introduction to using this panel.

Action

Select from one to ten columns or keys whose values you want sorted to determine the order of rows in your query output. Place any character in the Select column next to your choices and press <PF4> CONTINUE or Enter 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.

QUERY NAME:

The name you assigned this query.

Columns

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

TABLE NAME/ KEY(*) OR COLUMN NAME

The names of columns or keys in the tables you selected for this query. If a name is asterisked, it is a key. Keys are preferred over columns for faster processing.

DESCRIPTION

The Datadictionary description assigned each column.

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.

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 the Define Temporary Result (DQH90) 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.