COLSTAT Test Shows Column As NULL But It Has Valid Data (Doc ID 2216352.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.1 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Using GG version 12.1.2.1.5 for DB2 , running on OS/400 , tables(files) are captured and written to a local trail file.
An rpg program is used to populate the tables. Dates have the following format yyyy-mm-dd . Jan 1 , 2000 would be stored as 100-01-01
Replicat uses a macro to translate the DATE column in this format yyyy-mm-dd
The process works for the majority of years but fails for the year 2000.
COLSTAT believes it is null and drives the macro to set the date to 0099-01-01 instead of .100-01-01

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