Valid for
Extract, Replicat
Description
Use GETUPDATEBEFORES
or IGNOREUPDATEBEFORES
to include or exclude before-images of update records from the specified EXTFILE
. Before-images contain record details before an update (as opposed to after-images). IGNOREUPDATEBEFORES
remains in effect until GETUPDATEBEFORES
is entered. Once entered, GETUPDATEBEFORES
remains in effect until IGNOREUPDATEBEFORES
is entered.
Within your user exit code, you can compare before-images with after-images to identify the net results of a transaction, rather than the final state of a record. For example, if a BALANCE
field is $100 before a transaction and $120 after, comparison would show the difference of $20 occurring in that transaction.
Default
IGNOREUPDATEBEFORES
Syntax
GETUPDATEBEFORES | IGNOREUPDATEBEFORES