Before value—%BEFORE

Use this function when you want CDC Replication to retrieve the value of a source column before applying an update.

Syntax

%BEFORE(value)

Parameters

value: Specifies the name of a source column. You cannot specify a journal control field, an expression, or a column function as the input parameter.

Result data type

The data type of the source column (value). When a row is inserted into the target table, including all rows that are inserted during a refresh, this function returns NULL. Otherwise, this function returns the appropriate default value for the data type of the target column.

Examples

%BEFORE(CRLIMIT)

Returns the previous value in the CRLIMIT column, before it was updated on the source by the change being replicated.