Return Values

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following table lists the default attributes for the result of SUM(x).

Data Type of Operand Data Type of Result Format Title
BYTEINT or SMALLINT INTEGER Default format of the INTEGER data type Sum(x)
character FLOAT Default format for FLOAT
UDT Same as the operand Format for the data type to which the UDT is implicitly cast
DECIMAL(n,m) DECIMAL(p,m), where p is determined by the rules in the following rules:
If MaxDecimal in DBSControl is 0 or 15 and
  • n  ≤  15, then p = 15.
  • 15 < n  ≤  18, p = 18.
  • n  > 18, then p = 38.
If MaxDecimal in DBSControl is 18 and
  • n  ≤  18, then p = 18.
  • n  > 18, then p = 38.

If MaxDecimal in DBSControl is 38 and n  = any value, the p = 38.

Default format for the data type of the operand Sum(x)
Other than UDT, SMALLINT, BYTEINT, DECIMAL, or character Same as the operand Default format for the data type of the operand