Issue with comparing data between a DB2 server and an oracle server

Hello,

I am comparing data between a DB2 server and an oracle server.

I'm doing this on a SQl server using 2 linked servers.

I'm joining a table on each side and return any rows where some data is different with what column is different.

This is working well for most tables I have worked with so far but one.

this last comparison shows me differences in one of the fields, however when I query each system individually, there's no data... I have converted the value to an ASCII decinal value and both come back with a value of 0... Why would SQL server show these as different?

Thanks
Ludwig_dAsked:
Who is Participating?
 
Ludwig_dConnect With a Mentor Author Commented:
I found the solution, I had to hex() this column on the DB2 side and then ascii() the oracle side and both sides matched fine.
0
 
momi_sabagCommented:
is this the only table that has no data? or do other tables with no data work well?
0
 
Ludwig_dAuthor Commented:
hi,

other tables with no data are fine.
0
 
momi_sabagCommented:
does this table has a column with a data type that does not appear on other tables that work fine?
0
 
Ludwig_dAuthor Commented:
found my own solutuion
0
All Courses

From novice to tech pro — start learning today.