How to change the culture of the DB2 adapter?
Hi
When deploying my BTS 06 app onto a staging server, the server is in Europe and the DB2 receive adapter converts decimal points according to the local culture so they arrive from the DB2 adapter as commas instead of dots. Is there a way of changing this, without changing the culture of the staging server? I thought perhaps a setting I could put in btsntsvc.exe.config, or the UDL connection string, or some other config?
Any ideas appreciated!
Any chance that someone in the BizTalk product team could comment on this please? I'm really trying to engage my client's MS support contract but it's a very slow and arduous process - it's gonna come your way anyway 
I consider this a bug in the product: if decimal data is read from DB2, and schema validation is performed in the pipeline on this decimal field, it will fail. I don't have a workaround for this - right now I've had to turn off validation; furthermore, I've now got the problem going back the other way whereby eg 54.0000 in my updategram is interpreted as 540000 because the dot is interpreted as the thousands separator.
I hope someone can help - thanks!
