Issue with comparing data between a DB2 server and an oracle server
Posted on 2011-03-18
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?