COLSTAT Test Shows Column As NULL But It Has Valid Data
Last updated on APRIL 19, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.1 to 188.8.131.52.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Using GG version 184.108.40.206.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms