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 5 years ago by Whizkid. Reason: typo
- This topic was modified 5 years ago by Whizkid.