Supported formats for DB2/400 DATE columns - 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

DB2/400 databases allow multiple alternative formats in addition to the ISO standard format (YYYY-MM-DD) for columns defined with the DATE datatype. Database users can modify a formatting option for the column to change this default format to one of multiple others (for example to MM/DD/YYYY). Connect CDC, however, can capture only the following DATE column formats:

YYYY-MM-DDMM/DD/YYYY

DB2/400 DATE data represented in a format other than these is likely to cause the Connect CDC Change Selector to shut down.

Note: Connect CDC uses the YYYY-MM-DD format (only) when shipping data to a DB2/400 DATE column.