Veridata Compare Of DB2, Which Supports Empty String, To Oracle Which Doesn't Support Empty String, results in OOS (Doc ID 1461776.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 3.0.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Dec-2013***

Symptoms

 We are using OGG Veridata to compare DB2 to Oracle.  When we compare a table with DB2 empty string to Oracle null character columns all rows are flagged as OOS.  How can these be compared as equals?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms