| View previous topic :: View next topic |
| Author |
Message |
siddharth
Beginner
Joined: 25 Jul 2003
Posts: 15
Topics: 7
|
 Posted: Fri Feb 06, 2004 2:32 am Post subject: Help on SYNCSORT (File Comparison). |
 |
|
Hello,
I have two files:
File A: Containing 50000 records with record length 400 and with its first 50 bytes being the primary key.
File B: Containing 5 million records with record length 400 and with its first 50 bytes being the primary key.
So, the only difference between the two files is that the data in File A is the subset of the data in File B.
Note: Both the files are not sorted.
Now, If I have to delete/extract all the records from File B which are present in File A, can I do this using SYNCSORT utility??
Please let me know if anyone can help. Thank You.
Regards,
Siddharth. |
|
| Back to top |
|
 |
coolman
Intermediate
Joined: 03 Jan 2003
Posts: 283
Topics: 27
Location: US
|
| Posted: Fri Feb 06, 2004 3:53 am Post subject: |
|
|
Here is a DFSORT/ICETOOL job that will do what you want
| Code: |
//S1 EXEC PGM=ICETOOL
//OUT1 DD DUMMY
//OUT2 DD SYSOUT=*
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD DISP=SHR,DSN=INPUT.1
// DD DISP=SHR,DSN=INPUT.2
//TOOLIN DD *
SELECT FROM(CON) TO(OUT1) ON(1,50,CH) ALLDUPS USING(CTL3)
/*
//CTL3CNTL DD *
OUTFIL FNAMES=(OUT1,OUT2),SPLIT
/*
//
|
OUT2 would contain your "file2 records" which are in file1.
Hope this helps...
Cheers,
Coolman.
________
volcano classic review
Last edited by coolman on Sat Feb 05, 2011 1:34 am; edited 1 time in total |
|
| Back to top |
|
|
siddharth
Beginner
Joined: 25 Jul 2003
Posts: 15
Topics: 7
|
| Posted: Fri Feb 06, 2004 4:10 am Post subject: |
|
|
Thanks for the response.
But, we cannot use ICETOOL utilities on our application. Is there any way we can do this using SYNCSORT??
Please reply. Thank You. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
