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
If MaxDecimal in DBSControl is 18 and
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 |