Processing NULL values in the Expression Handler - Connect_CDC - 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

Since the Expression Handler can process column values from a DBMS, it necessarily has to deal with issues involving column values that are NULL. If all the source columns referenced in the expression are defined as “NOT NULL”, then NULL values are not an issue requiring action since they will not occur. If one or more of the referenced columns are “nulls allowed”, then the situation becomes more complicated.