|
View previous topic :: View next topic
|
| Author |
Message |
shanbalasay
New User
Joined: 22 May 2007
Posts: 19
Location: Belfast, UK
|
|
|
|
Can anyone tell me how to do the below.
1. Remove the Duplicates using SYNCSORT Utility
2. Write the removed duplicates onto another file
I used the below to remove the duplicates
SORT FIELDS=(1,44,CH,A),DYNALLOC=SYSDA
SUM FIELDS=NONE
I've heard of XSUM option to write the duplicates to a file. But I'd be grateful if anyone can tell me how to use it or any other option using SORT. |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
This is the method I've seen employed for SYNCSORT:
| Code: |
SORT FIELDS=(1,44,CH,A),DYNALLOC=SYSDA
SUM FIELDS=NONE,XSUM
|
|
|
| Back to top |
|
|
kirankumarj
New User
Joined: 18 Dec 2007
Posts: 51
Location: delaware
|
|
|
|
| Where do we specify the output dataset to which the duplicates should be written to? |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
SORTXSUM is the DDNAME for duplicates.
Gerry |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
Does Your site has both (DFSORT & Syncsot) products, same question is in this thread..
As said before SORTXSUM is the name, so JCL would have a structure like
| Code: |
//STEP1 EXEC PGM=SYNCSORT
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//*
//SORTIN DD DSN=INPUT
//*
//SORTOUT DD DSN=OUTPUT.WITHOUT.DUP
//*
//SORTXSUM DD DSN=OUTPUT.WITH.DUP
//*
//SORTWK03 DD UNIT=SYSDA,SPACE=(4096,(11664),,,ROUND)
//*
//SYSIN DD *
SORT FIELDS=(1,LENGTH,CH,A)
SUM FIELDS=NONE,XSUM
//* |
|
|
| Back to top |
|
|
|
|
