How to replace data of one file with data of another file

Archana B · New User Joined: 11 Jul 2012 Posts: 1 Location: India

Hi

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 )

916374 Sanjay Kumar
916389 Jawahar Pandit

Arun Raj · Posted: Wed Jul 11, 2012 12:55 pm

Archana B,

Welcome to the forums

!..You can very well achieve this using your sort product

Here is an example using Syncsort which works for your sample input (I have modified your FILE1 input key guess you have typo there). You can modify it as per your actual file attributes.

Gnanas N · Posted: Wed Jul 11, 2012 12:55 pm

Does File 2 have 72 records, as per your scenario?

Bill Woodger · Posted: Wed Jul 11, 2012 1:23 pm

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.