May 19, 2008, 10:44 AM
Mike TroutData Migrator - Read flat file for deletes
I'm new to DM and I'm mapping records from VSAM to DB2. Instead of refreshing the file (650k recs) I'm going to determine only those records that have changed in the source and either delete or insert records as necessary.
Can I read in a flat file of records to delete from DB2 and delete these through DM?
Thanks!
May 20, 2008, 09:56 AM
ClifSure. The source file should contain the key values of the rows in the target table you want to delete. Then in Target Properties select "Key Matching Logic" and for "If the record exists" select "Delete the existing record."