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