Try OpenEdge Now
skip to main content
SQL Development
Change Data Capture : Scalar Functions
 

Scalar Functions

For ease of interpretation of meta-data fields like _Change-FieldMap that are of the type VARBINARY and represent whether the corresponding fields in the Change table have changed or not, OE SQL provides two scalar functions:
*CDC_get_changed_columns
*CDC_is_column_changed
* CDC_get_changed_columns
* CDC_is_column_changed