|
|
| Author |
Message |
Prabha
Warnings : 1
Active User
Joined: 05 Dec 2005
Posts: 64
|
|
|
|
Hi,
I have 2 input files of same length.
FIle1:
1
2
3
4
File2:
2
3
4
5
Now o/p should be:
1
5
This is to get unmatched records from both files. Pls help out this. |
|
| Back to top |
|
 |
References
|
 Posted: Sat May 24, 2008 4:35 pm Post subject: Re: How to get unmatched records from two files |
|
|
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1004
Location: Chennai - India
|
|
|
|
prabha,
you can use the SELECT operator of ICETOOL. Search this forum and you will find MANY similar topics. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4190
Location: San Jose, CA
|
|
|
|
Prabha,
You can use a DFSORT/ICETOOL job like the following to do what you asked for:
| Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD *
1
2
3
4
/*
// DD *
2
3
4
5
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(CON) TO(OUT) ON(1,1,CH) NODUPS
/*
|
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html |
|
| Back to top |
|
|
Prabha
Warnings : 1
Active User
Joined: 05 Dec 2005
Posts: 64
|
|
|
|
| Thanks for yr help. It worked fine. |
|
| Back to top |
|
|
|
|
