Linking to IBM DB2 replicated database using ODBC
lbrinkmann
Forums
I tried running my data query in excel and in idea.Neither are correct - Any thoughts on what I am seeing. I was hoping with only 4 fields that either Idea or Excel could import the data correctly, but no luck.Thanks!
Excel
Comment = text = correct
Comment id = column is missing = wrong
Created by = alphanumeric = correct
Reg note id = column is missing = wrong
Idea
Comment = numeric (character) = wrong
Comment ID = hexadecimal (character)= wrong
Created by = alphanumeric (character)= correct
Reg note id = hexadecimal (character) = wrong
*note when I view this in Microsoft query all looks fine , but the view cannot be copied or saved and when it renders to excel is incorrect as above.
Hello and welcome to the site
Hello and welcome to the site. Unfortunately I haven't used ODBC drivers that much to be in a position to help you out. Hopefully someone else might be able to help or I would recommend you contact your IDEA distributor as they would hopefully be in a better position to help.
Brian