My Oracle Support Banner

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

Last updated on MARCH 19, 2019

Applies to:

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


Using GG version 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


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.