Using GUIDE in SQL Mode › Creating a Sample Query › Sample Procedure › Step 9: Specify Presentation Order

Step 9: Specify Presentation Order

This section tells how to specify the order of columns in the sample business report.

After you complete selection and calculation specifications for the sample query, CA Dataquery presents the panel shown following:

Ordering Rows: Priority (DQIE0)

 =>

 --------------------------------------------------------------------------DQIE0
 DATAQUERY: ORDERING ROWS: PRIORITY            QUERY NAME:    SQLGUIDE
 ------------------------------------------------------------------------------
 DETERMINE THE ORDER IN WHICH YOUR OUTPUT ROWS WILL BE RETURNED TO YOU BY
 ENTERING 1, 2, ETC. AS A PRIORITY NUMBER NEXT TO ANY COLUMN YOU WISH TO USE
 IN DETERMINING OUTPUT SEQUENCE.  SEQUENCE ASCENDING OR SEQUENCE DESCENDING
 MAY BE SELECTED BY PLACING ANY CHARACTER UNDER THE SEQUENCE ABBREVIATION.
 -------------------------------------------------------------------------------
 PRIORITY|TABLE NAME/                        |SEQUENCE|
 NUMBER  | COLUMN NAME                       |ASC/DESC| DESCRIPTION
 -------------------------------------------------------------------------------
         |CAI_SLSHST_TBL                     |        |
   __    | ITM_ID                            | X   _  |
   __    | SHIP_QTY                          | _   _  |
   __    | UNIT_PRICE                        | _   _  |
         |USER-DEFINED EXPRESSION            |        |
   __    | EXPRESSION   01                   | _   _  |
         |                                   |        |
         |                                   |        |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Facts

The following tells you the facts you need to finish creating the sample query.

Why does this panel appear?

Selecting Specify sequence... on the GUIDED QUERY CREATION: OPTION SELECTION panel (DQHV0) means you want to sort the output. This panel lets you specify sorting order.

Priority

With Guide, you can specify how you want the output data sorted on the report. The priority column lets you number the columns from major to minor sorts. You can sort on any number of columns.

Ascending (ASC)

You can sort from lowest to highest on any sort column.

Column Name

All columns selected for the output row and all results selected for the output row are listed here so you can specify which one contains data to sort by. You can sort on a result column just as you can with column data.

Steps

The following describes the steps required to complete the ORDERING ROWS: PRIORITY (DQIE0) panel for the sample query.

Step 1

Decide how the report should be arranged.

Step 2

Mark an X in the field next to ITM_ID.

Step 3

Mark an X in the ASC field following ITM_ID.

Step 4

Press <PF4> CONTINUE.

Options

Sort on additional columns

Within each group of ITM_IDs created by sorting the data by ITM-ID, you could also sort according to any other column.

Do not sort at all

You can skip this panel.

Sort on a different column

If you wanted to sort the report data according to total price, from the highest to the lowest, you could select Expression 01 and mark DESC.

Additional Information

The following provides additional information about the ORDERING ROWS: PRIORITY panel (DQIE0).

Descending (DESC)

You can sort from highest to lowest on any sort column.

Description

This column shows any CA Datacom Datadictionary description assigned to a column.

Control Breaks

Selecting columns for sorting on this panel means that you can use the selected columns as control breaks or page breaks for the report. Selecting them causes panels to appear during the report definition phase of execution that list those columns and allow you to designate control breaks or page breaks.