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|