Monetary Conversion

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Amerigo
Participant
Posts: 5
Joined: Wed Dec 17, 2003 8:41 am

Monetary Conversion

Post by Amerigo »

I have try with OCONV(number,"MD2[,".",",",,") but i have an error in the syntax in transformer stage.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Please use the documentation for the syntax, you missed a "]".

The command should be

Code: Select all

OCONV(number,"MD2[,".",",",,]") 
Alexandre
Participant
Posts: 12
Joined: Fri Dec 31, 2004 5:04 am
Location: Paris
Contact:

Post by Alexandre »

I think it is more like :

Code: Select all

OConv(number,"MD2[,'.',',',,]")
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Alexandre - Merci; you are absolutely correct. I'm not at a DS-enabled terminal now so I didn't test it and, of course, made a stilly misteak [sic] :shock:
Amerigo
Participant
Posts: 5
Joined: Wed Dec 17, 2003 8:41 am

Post by Amerigo »

Thanks a lot arnd and alexandre. :D
Post Reply