Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

926 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