I just want to know how we copy the content without deleting the old content in the destination file?
REPRO will not delete any contents!! It will just insert the data from input file to output file.
Say you have a record with key as "999" and want to repro another record with the same key of "999" then the REPRO will fail due to duplicate record (Default is NOREPLACE).
If you use REPRO with REPLACE then the old "999" record will be replaced with the new "999" record. Doesn't this mean deleting the old record and adding the new one?
Here is the link for the Optional parameters you can use with REPRO
http://publibz.boulder.ibm.com/cgi-bin/ ... 0956&CASE=Arun.