Is it possible to load an extract file (in DSNTIAUL format) as an update, rather than an insert ? My motivation for doing this is to gain efficiency by separating the inserts (which correspond to new records in production), from the updates. At the load stage, I want to insert all to cover the new records, and update only for updates (rather than implement the updates as delete / update).
or is there a utility that will recast the rows in the load file as SQL updates by reference to the catalogue ?
If you have millions records and only few gets change everyday then try to find the Delta records by using DFSORT any other product at your site comparing current vs last dataset, write a program to use MERGE.