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 220.127.116.11.1 to 18.104.22.168.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Using GG version 22.214.171.124.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!