Using of ROUND function

[Harshagks]

Hi,

I want to implement a ROUND function to get a value.
Like,
TOTAL AMOUNT = ROUND(Conversion Rate * Amount,4)

Example:
Conversion Rate = 1.234564
Amount = 56
TOTAL AMOUNT = 69.135584 but after the ROUND operator the value
sholud be 69.1356.

How can this be implemented in the Datastage?

[ray.wurlod]

Modify stage with output link having a scale of 4 for this particular Decimal data type. Use decimal_from_decimal() function with [round_inf] as the rtype argument.

[vivekgadwal]

Conversion Rate = 1.234564
Amount = 56
TOTAL AMOUNT = 69.135584 but after the ROUND operator the value
sholud be 69.1356.

Try this:

Code: Select all

 FMT(Arg1*Arg2, "R4") 

[ray.wurlod]

Not in a parallel job (unless in a BASIC Transformer stage).

[vivekgadwal]

Not in a parallel job (unless in a BASIC Transformer stage).

My bad...I haven't seen the "Parallel Job" note here!