DSXchange

Posted: **Thu Nov 11, 2010 11:55 pm**

Hi All,

could you please help how to round function in server jobs insted of trunc function in oracle

Ex: 6.6955 result : 6.7

Thanks in Advance support
Regards
SHRINIVAS

Posted: **Fri Nov 12, 2010 1:49 am**

Oconv(InLink.TheValue, "MD1P")

Posted: **Fri Nov 12, 2010 7:29 am**

There's also the FMT function, from what I recall.

Posted: **Fri Nov 12, 2010 6:43 pm**

FMT(InLink.TheValue, "10R1") will work but include leading space characters. You may need to wrap a TrimF() around that. For that reason I would prefer the Oconv() form.

Posted: **Tue Dec 13, 2011 12:59 am**

Use FIX function for rounding purpose

DSXchange

How to do round function in Datastage server jobs

How to do round function in Datastage server jobs