function for rounding

[hhh]

Hello friends,

in datastage px is there any function for rounding the value ? if not then what is basic methology to achive rounding in px ?

Thanks
Hiten

[balajisr]

Hi

I do not know whether any function is available or not for rounding up values. But In Edit column meta data dialog box when datatype is decimal there is a property called "Rounding" which you can use to round the source field to destination decimal values.

Check this out if you find this useful.

Regards
Balaji

[Nageshsunkoji]

Hi ,

I worked with function like ROUND_INF, for rounding the data.This function is called Rtype function which is compatable with type conversion functions.For example DecimalToDecimal((100.00/12),'round_inf').But this function is working finely up to 18 digits.After that this function is not giving proper results.

Ok,lets try with this function, if u r requirement will satisfy with this function.

Thanks&Regards
Nagesh.