I have FILE1 with 19K records . I extract 72 records from the main file and do special processing on those records and have the 72 records ready with same key but different data in another file.
Now i want to replace the 72 records of the master file with the 72 records of the new file , whereas the other records in the Master file should be retained. Only the 72 records which got changed should be replaced .
FYI , there are no duplicates in both the files, it is a FB
Ex : ( a simple example to illustrate the scenario )
The 6 digit no acts as a key .
FIle 1 :
916734 Jawahar Nehru
916839 Jawahar Pandit
File 2 :
916374 Sanjay Kumar
O/p file expected : ( one file should have both the data )
Does file one only have 72 records? I assume not, so remember to include the record-type in the key. Are both files in key order (including record-type for file one)? If so you can reduce resource usage by specifying SORTED on the JOINKEYS for one or both files.