Mainframe, MVS and zOS Discussion

Posted: **Wed Oct 15, 2014 2:47 pm**

Hi,

I have a file file-1 in which some records are present. Some of them are duplicate. I want to copy the records from this file1to output file, which are repeating more than 3 times. How I can achieve this?

Posted: **Wed Oct 15, 2014 3:10 pm**

Yes, look at ICETOOL's SELECT operator, which has many options to deal with duplicate keys.

Posted: **Wed Oct 15, 2014 6:37 pm**

Hi,

As William has said, try this:

Code: Select all

//STEP1   EXEC  PGM=ICETOOL 
//TOOLMSG   DD  SYSOUT=* 
//DFSMSG    DD  SYSOUT=* 
//IN DD DSN=...  input file 
//OUT DD DSN=...  output file 
//TOOLIN DD * 
SELECT FROM(IN) TO(OUT) ON(p,m,f) HIGHER(3) 
/*

Mainframe, MVS and zOS Discussion

Copy duplicate records, more than 3, in output?

Copy duplicate records, more than 3, in output?

Re: Copy duplicate records, more than 3, in output?

Re: Copy duplicate records, more than 3, in output?