Lotus script agent using "*lsxlc"LCConnection(“db2”)
Domino installed on NT4 english but with regional configuration in spanish (decimal separator is ‘,’)
It works all fine except for DB2 fields of type NUMERIC(x,y) (where y>=1)
It just transfers the number ignoring the decimal separator.
For example, for a NUMERIC(2,5) field
12,67000 in DB2
I get in the lotusscript agent 1267000
(multiplied by 10000 !!!)
Anybody knows how to make it work correctly?
Or why it ignores the decimal separator of the number?
Thanks a lot!
J R