Solved

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

Posted on 2011-03-18
5
362 Views
Last Modified: 2013-11-11
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
0
Comment
Question by:Ludwig_d
  • 3
  • 2
5 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 35169423
is this the only table that has no data? or do other tables with no data work well?
0
 

Author Comment

by:Ludwig_d
ID: 35173677
hi,

other tables with no data are fine.
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 35189520
does this table has a column with a data type that does not appear on other tables that work fine?
0
 

Accepted Solution

by:
Ludwig_d earned 0 total points
ID: 35217461
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
 

Author Closing Comment

by:Ludwig_d
ID: 35252784
found my own solutuion
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question