Skip to main content

Linking to IBM DB2 replicated database using ODBC

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. 

Brian Element Wed, 09/23/2015 - 08:25

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