We have a problem with reading/writing decimals. It appeared after we transferred our project from Win DS Server to AIX server. Our locale is ru and decimal separator is comma. When we try to set this separator as comma in the job properties everything is fine except values between 0 and 1 - datastage multiply them by 100 (for example, 0,41 becomes 41,00). It's like DS thinks these are percents?
The only one way to overdo this trouble is to cast decimal fields into double. But the project is very big and it'd take a lot of time to fix this trouble using this way...
Does anyone know another way?
Pinned topic Problem with DECIMAL fields in DB2 Connector on AIX DS server
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-07-29T09:04:49Z at 2011-07-29T09:04:49Z by SystemAdmin
Re: Problem with DECIMAL fields in DB2 Connector on AIX DS server2011-07-29T08:49:15ZThis is the accepted answer. This is the accepted answer.found this topic - https://www-304.ibm.com/support/docview.wss?uid=swg1JR38604 but I don't know is it my problem ("distort"). Does they have smth like this but for 8.1 DS version?
Re: Problem with DECIMAL fields in DB2 Connector on AIX DS server2011-07-29T09:01:58ZThis is the accepted answer. This is the accepted answer.https://www-304.ibm.com/support/docview.wss?uid=swg1JR37124 - found this! now the problem is to download it and to install)