When the type of input column (or the source column )is decimal(13,4) but the output is decimal(13,2) ,the value will be rounded off .
In DB2 enterprse stage,I can use 'cast' function to prevent rounding off,but how can i do in such as aggregate stage.
Is there any setting option to avoid rounding off in datastage?
In the administration environment properties, I set "APT_DECIMAL_INTERM_ROUND_MOD" as discard and unpresentable fractional digits.
but seems nothing changed
The datatype of calculated filed in aggregator will always be float. Is is not Decimal but you can do a conversion in transformer stage after the aggregation. Use DfloatToDecimal() function.
but can anyone explain why the envrionment variable "apt_decimal_interm_round_mode" does't work.
I just select one record 0.7499 (decimal(13,4)) and put it in an decimal(13,2) column,the results are both 0.75 whether set the variable as "to nearest" or "discard rounding"