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 a system setting. | 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 |