Compare Files in Natural

Shivendu · Posted: Mon Apr 06, 2009 10:59 am

Need to write a natural program to compare data in two files FILE1 and FILE2. Data which is present ONLY in FILE2 should be written to a new file FILE3.
Please help.

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Can you please clarify a bit..that what exactly you are looking for ??

Data structure of your FILE1 and FILE2 are same ?

If yes then you can use following logic to create a program.

1) Create data definition for your FILE1 record and FILE2 record.
2) Select a key( Combination of 3-4 vars) from FILE2 and do a look up in FILE1.
3) Now if match does not occur then write the record into FILE3

ofer71 · Posted: Mon Apr 06, 2009 6:12 pm

Why can't you invoke SORT from within Natural? (you can use ICETOOL with the ALLDUPS operand).

O.

Shivendu · Posted: Mon Apr 06, 2009 6:34 pm

Thank you all! I did it through ICETOOL.