trunc a decimal number to the X position

[Datamine]

Hello Everyone,

I've tried to find it here but without luck, so here is my question,

i want to "trunc" a decimal number up to the 3rd position after the decimal separator, i don't want to round the number.

for example:
i have a decimal number --> 1785.65897
and i want the result to be --> 1785.658

what is the simplest why to accomplish it in Datastage?


thanks,
Datamine

[dganeshm]

Two ways :

Change the precision of the decimal to n,3
Treat as a string , do a substring from 1 to index of 1st occurence of '.' + 3.

[gaya3]

you can use the oconv format function for decimal conversions.

Oconv(1234.567, "MD20T") will give 1234.56 without rounding off. Replace '2' in MD20T with the number of decimal places that you want in your output.

[Datamine]

o.k - thanks for the info,

can i also use the function FMT?

[ArndW]

I prefer "INT(In.NumberColumn/1000)*1000" to get 3 decimal positions.

[Datamine]

from a performance point of view, which one of the method mentioned above is the fastest?

[ray.wurlod]

I believe that, of the options listed, Fmt() would be most efficient.