MQSeries.net :: View topic - Problems with CAST function when decimal point is COMMA

EVILLAREJO · Posted: Fri Oct 25, 2002 4:55 am Post subject:

Hi,
I write you from Spain. Usually in Spain we use the COMMA as decimal point. I have this problem:
I receive in a XML file a tag similar to this:

<TotalPurchaseOrder>12345,97</TotalPurchaseOrder>

In a compute node, I'm using the CAST function to try to convert this string to DECIMAL, in order to know the number of scale digits. MQSI doesn`t work.

But, if I replace manually in the XML file and I change "12345,97" and I write "12345.97" MQSI works fine.

Do you know how to solve this problem? I need to work with COMMA as decimal point.

Thank a lot.