Page 1 of 1

To split matched and unmatched records into 2 files

Posted: Thu Dec 11, 2008 5:30 pm
by dssenthil
hi,
i need easytrieve program for my requirement given below:
i have 2 input files.i need to compare the two files and
i need two output files as below :

output1: contains the matched records

output2: contains unmatched recods

Please do the needful.

Posted: Thu Dec 11, 2008 5:57 pm
by Natarajan
Hi Senthil,

I have the answer... but please post the topic in appropriate forum.
Please post it in easytrieve forum. i will give answer there.

moderators - Please move/delete this topic from here.

Posted: Thu Dec 11, 2008 6:37 pm
by Krishna
Moved this topic to EASYTRIEVE forum.
kept the copy of this topic in ENDEAVOR forum for reference.
i will delete that copy in 2 days.

EASYTRIEVE MATCHING LOGIC

Posted: Thu Dec 11, 2008 6:43 pm
by Natarajan
Thanks krishna.

Senthil,

Here is the job card which will do the required. I assume that you know
how to define the files in easytrieve.

Below example match the input files based on EMPNO field.

Code: Select all

  JOB INPUT (FILE1 KEY(SO-EMPNO) +                
            FILE2   KEY(AO-EMPNO) )              
                                                 
                                                 
     IF MATCHED                                  
        PUT OUTPUT1                              
     ELSE                                        
        PUT OUTPUT2                              
     END-IF                                      

Posted: Wed Dec 17, 2008 11:25 am
by dssenthil
Thanks a lot....