ICETOOL Compare...



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

ICETOOL Compare...

Postby Pakelika » Tue Mar 03, 2009 7:08 am

Hello,

I am sorta new to the IBM mainframe and was wondering if it is possible to use the Icetool to compare 2 files 'ra11111.test.source(file1)' and 'ra11111.test.source(file)' and have all duplicate records listed in another file 'ra11111.test.source(file3)'?

The files i will be comparing will be as followed:

File 1
itcp2001
itcp2002
itcp2003
itcp2004

File2
a
itcp2002
itcp2004
dfreport

File3 (desired)
itcp2002
itcp2004

Thanks for the help in advance
-cjb
Pakelika
 
Posts: 1
Joined: Tue Mar 03, 2009 3:12 am
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL Compare...

Postby dick scherrer » Tue Mar 03, 2009 7:51 am

Hello and welcome to the forum,

Please check out this prior topic:
dfsort-icetool-icegener/topic845.html

Also, see "Create files with matching and non-matching records" Smart DFSORT Trick at:
http://www.ibm.com/systems/support/stor ... vs/tricks/
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: ICETOOL Compare...

Postby Frank Yaeger » Tue Mar 03, 2009 10:00 pm

cjb,

You can use a DFSORT/ICETOOL job like the following to do what you asked for. I assumed your input files have RECFM=FB and the same LRECL, and that there aren't any duplicates within input file1 or within input file2. If those assumptions are incorrect, then you need to give more details about the actual situation.

//S1   EXEC  PGM=ICETOOL
//TOOLMSG   DD  SYSOUT=*
//DFSMSG    DD  SYSOUT=*
//CON DD DSN=...  input file1
//    DD DSN=...  input file2
//OUT DD DSN=...  output file
//TOOLIN DD *
SELECT FROM(CON) TO(OUT) ON(1,8,CH) FIRSTDUP
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post