I need to add records to a table which already has some rows present in it.I have to do this using the load jcl. One method which I could think of is
1. Do the unload for the table first.
2.Append the new records to this unload file.
3. Delete the existing data in the table
4.Load the table using the appended unload file.
Can any one suggest a better approach where probably I can avoid the delete step?
Joined: 06 Sep 2007 Posts: 785 Location: Chennai, India
Which load utility you are using?
If it is BMC load plus, it avoids adding rows and keys to the table spaces and indexes if they cause duplicate keys in a unique index, so that the rows and keys do not need to be deleted later in the LOAD phase...
I am using DSNUTILB in the load jcl. Its like I have loaded the table for some employee ids and now I want to append it for remaining employee ids. So I guess there will not be an issue of duplicate keys.