17.10 - Return Values - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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