Thousands separator

Simona · Post by **Simona** » Fri May 13, 2005 10:28 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri May 13, 2005 10:37 am

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

Simona · Post by **Simona** » Fri May 13, 2005 10:50 am

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

Oconv is not applicable to a Parallel job.

Thanks,
S.

T42 · Post by **T42** » Fri May 13, 2005 11:08 am

You can use Basic Transformer to handle this.