DQL Statements › SET Statements › Arithmetic Result Syntax Diagram

Arithmetic Result Syntax Diagram

Purpose

You can set the value of a temporary result to be the value that results from an arithmetic expression.

Syntax Diagram

The following is the syntax for the SET statement when you want to set the result to equal the value resulting from an arithmetic expression.

►►─ SET ─ result ─┬─────────┬─ =arithmetic-expression ────────────────────────►◄
                  └─ (n.d) ─┘

Explanation

The following explains the keywords in the preceding format.

result

Assigns a name to the new result. A result name can be up to 32 alphanumeric characters, with an alphabetic first character.

(n.d)

Specifies the precision (the specific number of digits before and after the decimal) of the result, overriding the default precision. (n.d) indicates that the result contains n integers and d decimals. The total of n + d cannot exceed 18 digits.

For example, (9.2) specifies a result with nine integer positions and two decimal positions. The total number of digits is 11.

arithmetic-expression

Specifies one or more arithmetic operations to be performed on selected data, including null-valued columns. If a computation is done involving null values, the result is null. CA Dataquery evaluates the expression according to the hierarchy of operations. (For more information, see Evaluation of Arithmetic Expressions.)

Sample

This is a sample query which illustrates SET statements using arithmetic expressions.

    FIND CAI-SLSHST-REC ROWS
        WITH SHIP-QTY GTE 200
      RELATED BY SLMN-ID TO CAI-ORDERS-REC
    SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
    SET DISCOUNT (5.2) = NET-COST * DISC-PCT
    SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT
    PRINT FROM CAI-ORDERS-REC ORD-ID
          FROM CAI-SLSHST-REC ITM-ID
                              SHIP-QTY
                              UNIT-PRICE
                              NET-COST
                              DISCOUNT
                              DISCOUNT-COST

Sample

The CAI-SLSHST-REC table looks like this:

Sample

The CAI-ORDERS-REC table looks like this:

Sample

The active found set for the preceding query looks like this: