| View previous topic :: View next topic |
| Author |
Message |
gharidoss
Beginner
Joined: 14 Mar 2005
Posts: 38
Topics: 15
Location: Bangalore
|
 Posted: Tue Mar 14, 2006 2:35 am Post subject: Find No match records using DFSORT |
 |
|
Hi,
I want to extract the not matching records from two files by using DFSORT
File1
11
22
33
44
File2
22
33
Desired Output
11
44
I can acheive this output by using ICETOOL or SPLICE
| Code: |
//TOOLIN DD *
SELECT FROM(INPUT) TO(OUTPUT) ON(1,2,FI) NODUPS
|
I want to know, can I acheive this result by using DFSORT?
Thanks,
Hari |
|
| Back to top |
|
 |
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Tue Mar 14, 2006 4:32 am Post subject: |
|
|
Hari,
ICETOOL is actually a part of DFSORT. Anyway, if you want to try with PGM=SORT, then try the solution provided in this link
http://www.mvsforums.com/helpboards/viewtopic.php?p=15#15
Note: You have to split the ICETOOL step into 3 SORT steps and take the output of OUTFIL FILEA.
Try and let us know if you face any problems,
Thanks,
Phantom |
|
| Back to top |
|
|
gharidoss
Beginner
Joined: 14 Mar 2005
Posts: 38
Topics: 15
Location: Bangalore
|
| Posted: Tue Mar 14, 2006 4:39 am Post subject: |
|
|
Hi Phantom,
Thanks for the link.
Thanks,
Hari
_________________
http://mainframe-world.com |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Tue Mar 14, 2006 11:43 am Post subject: |
|
|
Hari,
Given that ICETOOL is included with DFSORT (has been since 1991), why would you want to use a less efficient method with DFSORT instead of a more efficient method with DFSORT's ICETOOL?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
