Use this check box to determine whether the before image of a selected source column will be captured, in addition to the after-image. The before image provides an image of the column prior to being updated, useful for recovery.
The Capture before image check box must be selected for all columns if the table might be used for update anywhere replication.
When selected, a column is replicated to the target table containing the values of the source table column before the values were updated. By default, the name of the before-image column begins with the prefix character, X. For example:
XNAME
This character must be unique. If any column in the target table already begins with X, a different, unique prefix character is used. If there are no unique characters, before-image columns cannot be selected.
[ Top of Page | Table of Contents | Glossary | Index ]