Comparing the duplicates

vinay249 · New User Joined: 18 Apr 2007 Posts: 13 Location: Bangalore

Hi,

I have a requirement

File A : I have 6 records out of which 4 are same.

File B: I have 8 records out of 6 records are same.

The 4 records in FILEA and 6 records in FILE B are same. If we substract we will get two records, I need these two records in output file

This is because to remove the duplicates from the database.

Through easytrieve we can compare but for that there should not duplicates, but in my file I have duplicates.

Thanks in advance!!

dick scherrer · Posted: Mon Sep 22, 2008 9:26 pm

Hello,

You need to post the content of both files and the output you want when those files are processed. Post the nputs and output using the "Code" tag at the top of the Reply panel. Use Preview to see how your post will appear to the forum and when you are satisfied with the appearance of your post, click Submit. Make sure you Submit or your post will be lost.

If there are more (or could be less) than exactly 6 and 8 records in each file, show this in your examples.

vinay249 · New User Joined: 18 Apr 2007 Posts: 13 Location: Bangalore

Please see the the inputs and outputs

dick scherrer · Posted: Tue Sep 23, 2008 1:58 am

Hello,

Do not post the same question multiple times.

The other topic in the other forum has been deleted.

d

Selva-kumar · New User Joined: 01 Mar 2007 Posts: 52 Location: chennai

Hi Vinay,

Need one clarification. If duplicates in a File A matches with the duplicates in File B

1. , Then you need a single occurrence of that duplicate from File A and a single occurrece of that duplicate from File B

(or)

2. You just want the number of records equal to the difference between the duplicates in file A and file B

kalpana manoharan84 · New User Joined: 18 Sep 2008 Posts: 4 Location: Chennai

Hi,
I assume your requirement as FILEA minus FILEB.[i.e.]Output File should contain the records present in FILEA ,that is not available in FILEB.

Eg:

FILEA:

AAAAA
AAAAA
BBBBB
CCCCC
FILEB:

AAAAA
CCCCC
DDDDD

Output should be:

AAAAA
BBBBB

If this is the case,the following code will help you.

//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=TSOXXXX.FILEA,DISP=SHR
//SORTOUT DD DSN=TSOXXXX.FILEA.O,DISP=(NEW,CATLG,DELETE),
// SPACE=(TRK,(5,1)),
// DCB=LRECL=080,BLKSIZE=800,RECFM=FB),UNIT=SYSDA,DSORG=PS
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE
OUTREC OVERLAY=(10:C'W')
/*
//*
//STEP2 EXEC PGM=SORT
//SORTIN DD DSN=TSOXXXX.FILEA.O,DISP=SHR
// DD DSN=TSOXXXX.FILEB,DISP=SHR
//SORTOUT DD DSN=TSOXXXX.OUTPUT,DISP=(NEW,CATLG,DELETE),
// SPACE=(TRK,(5,1)),
// DCB=(LRECL=080,BLKSIZE=800,RECFM=FB),UNIT=SYSDA,DSORG=PS
//SYSOUT DD SYSOUT=*
//SYSIN DD *
INREC OVERLAY=(07:C'001')
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=(07,3,ZD)
OUTFIL FNAMES=SORTOUT,BUILD=(1,5,75X),INCLUDE=(7,4,CH,EQ,C'001W')
/*
//

Arun Raj · Posted: Tue Sep 23, 2008 7:15 pm

Kalpana,

Did you notice the sample input/ouput provided in the OP's last post where the unmatched records from either of the files is not seen in the output?

Vinay,

Please make your requirement more clearer with all the possible scenarios in input and the 'rules' for extracting records so that somebody here might be able to help you.