Solved

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

Posted on 2011-03-18
5
364 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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

Suggested Solutions

Title # Comments Views Activity
How come this XML node is not read? 3 53
SQL Syntax Question 9 56
SQL Server for XML PATH giving wrong results. 6 59
Search Text in Views 2 28
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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
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…

734 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