Panels › (DQHB0) Define the Arithmetic Expression

(DQHB0) Define the Arithmetic Expression

 =>
 Press <PF1> for help with writing the arithmetic expression
 --------------------------------------------------------------------------DQHB0
 DATAQUERY:  DEFINE THE ARITHMETIC EXPRESSION       QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Write an arithmetic expression to be used in calculating the value of
 temporary result  ________________________________  with precision _____.
 Use the column numbers, F01, F02, etc., numeric literals, or a combination of
 both and arithmetic operators.
 The default calculation appears below. You may type over it to change it.
 => ___________________________________________________________________________
 -------------------------------------------------------------------------------
 NUMBER| TABLE NAME/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 Guided Query Define the Arithmetic Expression panel is required only if you named a Temporary Result. One panel appears for each Temporary Result you named. With it, you type an algebraic equation that may be simple or complex, can contain numbers like F01 and F02 that represent column names, or literal values. An introduction to this panel appears in the CA Dataquery User Guide. You can define any arithmetic expression on this panel that could be defined in a DQL SET statement.

Action

Accept the default expression or enter a valid calculation whose result will provide the value of the temporary result for each row for which the calculation is made. You can write over the default expression. For more information about arithmetic expressions in temporary result calculations, see the chapters on query syntax.

Display Fields

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

QUERY NAME:

Name you assigned to this query.

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 13.2 default precision.

Columns

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

NUMBER

Number CA Dataquery has assigned each numeric column you selected for use in structuring your calculation.

TABLE NAME/ COLUMN NAME

Names of the columns you selected for use in structuring your calculation, along with their table names.

DESCRIPTION

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

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 Select Columns for Calculation (DQHA0).

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