DSXchange

Posted: **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.

Posted: **Thu Sep 11, 2008 8:45 am**

use Fix function

Posted: **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.