Process out of range data values - aws_mainframe_modernization_service - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

If the source date, time, or timestamp values are out-of-range for a target column, Connect CDC updates the target column with NULL. For example, if you have a DB2 DATE datatype mapped to a SQL Server DATETIME datatype or SMALLDATETIME datatype; DB2 supports date values from the year 0001 to 9999 but the valid range of values for SQL Server is a subset of those values. If a DB2 date value is sent to a SQL Server target column and the value is out-of-range, Connect CDC silently substitutes a value of NULL.