DSXchange

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?

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.

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

Try this:

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

ray.wurlod wrote:Not in a parallel job (unless in a BASIC Transformer stage).

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