(DQHI0) Column Definition

 =>
  Press <PF1> for help with defining the report
 --------------------------------------------------------------------------DQHI0
 DATAQUERY:  COLUMN DEFINITION                 QUERY NAME:
 -------------------------------------------------------------------------------
 Specify the order in which the columns are to appear on the report by
 inserting an order number below.  Column functions may be selected by placing
 any character in the corresponding input fields.
 -------------------------------------------------------------------------------
 ORDER | TABLE NAME/                       |     |     |     |     |     |
 NUMBER|  KEY OR COLUMN NAME               | AVG | MAX | MIN | SUM | CNT | TOT
 -------------------------------------------------------------------------------
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
       |                                   |     |     |     |     |     |
 -------------------------------------------------------------------------------
 <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 Column Definition panel can be accepted with the defaults CA Dataquery assigns, resulting in report data printed in columns in the same order in which it was selected. However, you may want to change the order in which columns are printed.

You may also want to request that mathematical functions be performed on some or all numeric columns. If so, you will select math functions for columns. At the end of the report, or at control breaks that you can specify later, you can obtain the results of the functions and specify a special legend to identify them on the report.

Refer to the CA Dataquery User Guide for a complete explanation of each available column function and an introduction to using this panel.

Action

Number the columns in the order wanted in the Order Number column. Enter any character in a column function column you want to perform on a particular column. Press Enter or <PF4> CONTINUE 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:: Name assigned the query you are defining.
TABLE NAME/ KEY OR COLUMN NAME: Lists all columns and keys in tables chosen along with table names.

Columns

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

ORDER NUMBER: Numbers appearing in this column are assigned automatically by CA Dataquery. Change the numbers as needed by typing over the current number to indicate the order of columns on the report.
AVG: Enter a character in this column next to any column or key for which you want CA Dataquery to produce an average at control break or at the end of the report.
MAX: Enter a character in this column next to any column or key for which you want CA Dataquery to produce the maximum amount found at control break or at the end of the report.
MIN: Enter a character in this column next to any column or key for which you want CA Dataquery to produce the minimum amount found at control break or at the end of the report.
SUM: Enter a character in this column next to any column or key for which you want CA Dataquery to produce a total at control break or at the end of the report.
CNT: Enter a character in this column next to any column or key for which you want CA Dataquery to produce a count of the data items in this column at control break or at the end of the report.
TOT: Enter a character in this column next to any column or key for which you want CA Dataquery to produce totals at control breaks and at the end of the report and for which you do not need to assign legends different from those assigned automatically by CA Dataquery.

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 Report Column Definition (DQHG0) 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.