Topic
  • 3 replies
  • Latest Post - ‏2011-07-29T09:04:49Z by SystemAdmin
SystemAdmin
SystemAdmin
2105 Posts

Pinned topic Problem with DECIMAL fields in DB2 Connector on AIX DS server

‏2011-07-29T08:10:54Z |
Hello, guys!

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?
Updated on 2011-07-29T09:04:49Z at 2011-07-29T09:04:49Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2105 Posts

    Re: Problem with DECIMAL fields in DB2 Connector on AIX DS server

    ‏2011-07-29T08:49:15Z  
    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?
  • SystemAdmin
    SystemAdmin
    2105 Posts

    Re: Problem with DECIMAL fields in DB2 Connector on AIX DS server

    ‏2011-07-29T09:01:58Z  
    https://www-304.ibm.com/support/docview.wss?uid=swg1JR37124 - found this! now the problem is to download it and to install)
  • SystemAdmin
    SystemAdmin
    2105 Posts

    Re: Problem with DECIMAL fields in DB2 Connector on AIX DS server

    ‏2011-07-29T09:04:49Z  
    https://www-304.ibm.com/support/docview.wss?uid=swg1JR37124 - found this! now the problem is to download it and to install)
    and again... it's only for 8.5