deva_048 wrote:NF1 contains 9lakh records
NF2 contains 7 lakh records
Used above posted jcl in control cards (1,21,a) I need to obtain remaining 2 lakhs records
i/p strucuture WILL BE LIKE THIS:
APLU027951387 ,161524310 ,1803565,179 ,04/07/2012,8 ,00992501102000506963 ,0400646871093,0400646871093,4,147020074 ,03/29/2012,C,ICM11300,2012-03-29-20.04.54.439028
SORTJNF1 : RCD IN= 982245,OMITTED= 0,PAIRED= 982245,UNPAIRED= 0
SORTJNF2 : RCD IN= 742926,OMITTED= 0,PAIRED= 742926,UNPAIRED= 0
This shows that all of the records on both files were matched.
So, you have 742,926 on JNF2, unknown whether there are duplicates. 982,245 on JNF1 which consist of the 742,926 keys (you have specified) on JNF2 plus around 240,000 duplicates of keys on JNF2.
I don't know what you mean by "I need to obtain remaining 2 lakhs records".
You will get no output on your SORTOUT, as you have no unmatched records on JNF1.
Check that your keys are defined correctly, including taking account of RDW for variable-length records if you have them.