Solved

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

Posted on 2011-03-18
5
365 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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…
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.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

627 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