My Oracle Support Banner

Blank to Null Conversion (Doc ID 2330478.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle GoldenGate Veridata - Version and later
Information in this document applies to any platform.


I have migrated the data from DB2 iSeries to Oracle DB. I have converted blanks to NULL using SPACESTONULL function in Goldengate. I'm using Veridata to compare the tables between iSeries DB and Oracle DB. Since I converted spaces to null, all those records are showing as differences. How do I skip null values in comparison?. This means, I don't want veridata show a difference exists if same field is blank in iSeries and null in Oracle.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.