How Teradata loads “0” length character strings - 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

For most databases there is a mechanism to update a character string of “0” length into a VARCHAR column. Connect CDC can identify that a character string is “0” length, and the Applier can update a “0” length string into a target database.

However, for Teradata, there is no mechanism when writing the data file, that the Applier can use to differentiate between a value with “0” length and a NULL value. To differentiate between these 2 values, the Applier checks for a character value which has a length of “0”, and then, in this situation, loads 1 space.