Delete some records from DSO in end routine
I need to wrtie some code in end routine of a transformation. Its a flat file load to a DSO. Purpose is to compare the already existing entries in active table of DSO with the result package and then delete the records from active table (by setting the recordmode to D) if the entry in active table does not match with any of thereords in the result package.
In active table of DSO following entries are present:
now new file comes with following data
I want that the record 20 A should get deleted, 40, 50 and 60 should remain as it is and 60E should be added to the DSO. So need to loop at DSO, search if 20 is present in result package..if yes, skip this record and if not set 0recordmode of this record in dso to 'D'. I need code (syntax) for this purpose. Please help.