How to do round function in Datastage server jobs

ysrini9 · Post by **ysrini9** » 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

ray.wurlod · Post by **ray.wurlod** » Fri Nov 12, 2010 1:49 am

Oconv(InLink.TheValue, "MD1P")

chulett · Post by **chulett** » Fri Nov 12, 2010 7:29 am

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

ray.wurlod · Post by **ray.wurlod** » 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.

prasad.bodduluri · Post by **prasad.bodduluri** » Tue Dec 13, 2011 12:59 am

Use FIX function for rounding purpose