?
Solved

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

Posted on 2011-03-18
5
Medium Priority
?
372 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

569 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