A variation of the standard Add operator is supported for adding two or more numeric expressions together, generating the SQL: expression1 + expression2 +…+ expressionN. Character expressions are automatically converted, if possible, to numbers before adding. The resulting numeric type depends on the type of the expressions. For information on binary arithmetic result data types, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145.
When dragging an Add All operator into a variable, the following tree element is created.
Columns and/or other expressions can be moved into the (empty) branches of the tree, where the first argument is to the left of the plus operator, the second to the right, and so forth. In the example below, numbers 1, 2 and 3 are added together to yield the SQL 1+2+3, which displays as 6.
There are no special properties for the Add All operator.