DSXchange

Hi,

In a parallel job I need to display a decimal number with thousands separator. Are there any functions available in Parallel for this formatting request? (I'm using Datastage PX 7.5.1)

1234567 should be represented as 1,234,567.00 in the output.

Could you please give me some ideas on how to achieve this?

Thank you in advance,
Simona

OConv(YourNumber * 100, "MD2,D")

Sainath.Srinivasan wrote:OConv(YourNumber * 100, "MD2,D")

Oconv is not applicable to a Parallel job.

Thanks,
S.

You can use Basic Transformer to handle this.