Has Column Value changed - 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

Method:   Has Column Value Changed

Function name:   HasColumnValueChanged

Parameter list:   (columnName)

Return type:   Boolean

What the method does:    Predefined conversion table. Returns true for the input source column in the current data row if the row is for a replication UPDATE row and the value for the particular column has changed.

This returns true if the column value is being changed either NULL to a value or from an actual value to NULL in addition to the obvious case where there is both an “old” value and a “new” value and they are different.

This method returns false if both the values are the same or both are NULL or either are skipped.

This method returns false if the row operation type is DELETE or INSERT.

This method would be useful to model the data distribution such that rows are replicated to a target table only when the columns relevant to the target table are updated.

The datatypes CHAR, DOUBLE, DECIMAL, and INTEGER are supported.