jzhardy
Active User
Joined: 31 Oct 2006 Posts: 131 Location: brisbane
|
|
|
|
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 ? |
|