DSXchange

Hello all, my input is decimal 4,2 and my output is smallint. So I am using Ceil func to get the closest value.

What I am expecting is

Ceil (7.04) =7

ceil(7.94)=8

But in both cases above, the output I am getting is 8. Let me know if there is another way around.

DataStage will adapt the input data to the output format, so, from a decimal to a smallint field just mapping your field will do the required conversion

Review the documentation for the Ceil function. It is not a rounding function.

You could try out the DecimalToDecimal function with the round_inf argument.

Mike

Thanks for the responses guys. DecimalToDecimal Worked.