round function

jani · Post by **jani** » Thu Sep 11, 2008 8:41 am

Hi,
I want to implement round function in my job.i.e rounding decimals to integer values.EX:round(3.5)=4 ,round(3.2)=3,round(3.6)=4

I am using datstage 7.5 serverjobs.

Please let me know the logic to implement this function in datastage job.
I want to use this function in stagevariable.

svga · Post by **svga** » Thu Sep 11, 2008 8:45 am

use Fix function

chulett · Post by **chulett** » Thu Sep 11, 2008 8:49 am

Welcome. :D

I typically use the FMT() function for this, but there are probably other ways as well.