Packed Decimal datatype in DB2

• Whizkid

  Right there with Babe

  Points: 783

  More actions

  November 28, 2019 at 7:24 am

  #3701845

  We are trying to get the value from DB2 database table via Linked Server in SQL server 2016. The DB2 table has one column with the data type of "Packed Decimal in the Length of 11 & Precision of 5". when I query this column in SQL server, I'm getting only the decimal value and not getting any precision value. For eg. In DB2 the actual value is "5.67234" where as in SQL Server giving the column value as "5.00000".

  How do I get the actual value (via linked servers)which is exactly available in DB2 from SQL Server 2016?

  • This topic was modified 4 years, 12 months ago by  Whizkid. Reason: typo
  • This topic was modified 4 years, 12 months ago by  Whizkid.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 29, 2019 at 8:10 am

  #3702052

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.