Valid for
Extract, Replicat
Description
Use GETDELETES
or IGNOREDELETES
to include or exclude delete records from the specified data source. GETDELETES
is in effect until IGNOREDELETES
is entered. Once entered, IGNOREDELETES
is in effect until GETDELETES
is entered.
Default
GETDELETES
Syntax
GETDELETES | IGNOREDELETES
Example
This example separates inserts, updates and deletes into three files.
IGNOREUPDATES IGNOREDELETES GETINSERTS EXTFILE $DATA1.EXTDAT.EXTRACT1 TABLE $DATA2.FINANCE.ACCOUNTS; IGNOREINSERTS GETUPDATES IGNOREDELETES EXTFILE $DATA1.EXTDAT.EXTRACT2 TABLE $DATA2.FINANCE.ACCOUNTS; IGNOREINSERTS IGNOREUPDATES GETDELETES EXTFILE $DATA1.EXTDAT.EXTRACT3 TABLE $DATA2.FINANCE.ACCOUNTS;