Single input file matching

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Single input file matching

Postby GRAMBO » Wed Aug 17, 2011 6:41 pm

I have a single input file, and am matching the items within it. Each record can have at most 1 matching record, sometimes there is no matche. (but no no duplicates)

I have the following JCL which is producing 1 record for each of the matching lines, as I want.

However, I am struggling to understand if it is possible to produce a seperate file of the unmatched items, I know this can be done with 2 input files, but can it be done with just one? Thanks.

//SPLICE03 EXEC PGM=ICETOOL,COND=(0,NE)                   
//TOOLMSG  DD  SYSOUT=*                                   
//DFSMSG   DD  SYSOUT=*                                   
//INFILE1  DD  DSN=DEA......... 
//OUT2     DD  DSN=DEA.........
//             DISP=(NEW,CATLG,DELETE),                   
//             SPACE=(CYL,(100,50),RLSE)                   
//TOOLIN DD  *                                                           
  SPLICE FROM(INFILE1) TO(OUT2) ON(5,37,CH) WITH(103,4) - 
  WITHALL KEEPNODUPS USING(CTL1)                           
//CTL1CNTL DD *                                           
  OUTFIL FNAMES=OUT2,                                     
Posts: 8
Joined: Fri Oct 15, 2010 10:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Single input file matching


Re: Single input file matching

Postby Frank Yaeger » Wed Aug 17, 2011 10:53 pm

If I understand what it is you want to do, the "Keep dropped duplicate records (XSUM)" Smart DFSORT Trick at: ... g3T7000094

shows how to do it.

If that's not what you want, then you need to do a better job of explaining what you're trying to do with sample input and expected output.
Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at
User avatar
Frank Yaeger
Global moderator
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times



  • Related topics
    Last post