Panels › (DQHA0) Select Columns for Calculation

(DQHA0) Select Columns for Calculation

 =>
 
 --------------------------------------------------------------------------DQHA0
 DATAQUERY:  SELECT COLUMNS FOR CALCULATION         QUERY NAME: _______________
 -------------------------------------------------------------------------------
 SELECT THE COLUMN(S) YOU WISH TO USE IN CALCULATING THE VALUE OF THE TEMPORARY
 RESULT ___total amt___________________________  WITH PRECISION _2___ .
 PLACE ANY CHARACTER NEXT TO THE DESIRED NAME(S).
 -------------------------------------------------------------------------------
 SELECT|  TABLE NAME/COLUMN NAME              |  DESCRIPTION
 -------------------------------------------------------------------------------
   X   |  Quantity                            |
       |  Item Description                    |
       |  Suppliers                           |
   X   |  Price                               |
       |                                      |
       |                                      |
       |                                      |
       |                                      |
       |                                      |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, completion of the Guided Query Select Columns for Calculation panel is not required for each Temporary Result Column named. Use it only if your arithmetic expression will include data found during query execution in a column.

With it, you tell CA Dataquery which columns you will use in an arithmetic expression to create the results you want. You can use up to ten columns. You will also be allowed to include literal values in your calculation.

Note: For more information about defining arithmetic expressions, see the chapters on query syntax. An introduction to this panel appears in the CA Dataquery User Guide.

Action

Select a column from the list of numeric columns for the files you selected that you want to be used in defining an arithmetic expression by placing a character in the select column next to the column names. Press Enter or <PF4> CONTINUE to go to the next panel.

Display Fields

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

QUERY NAME:

Name assigned this query with the first Guided panel.

RESULT

Name you assigned to the temporary result field you are currently defining.

WITH PRECISION

Precision you assigned the temporary result column you are currently defining, or the default (13.2) if none was assigned.

Columns

TABLE NAME/ COLUMN NAME

Numeric fields referenced in the query that may be used in the calculation that defines the temporary result column contents.

DESCRIPTION

The Datadictionary description of each column listed.

Entry Fields

Refer to the following chart for valid entries in the column 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 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.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.