|
View previous topic :: View next topic
|
| Author |
Message |
Durgesh Singh
New User
Joined: 15 Sep 2008
Posts: 12
Location: Pune
|
|
|
|
I am not able to place duplicate records in a separate file using SORT.
The JCL I am using is as follows:
| Code: |
//STEP04 EXEC PGM=SORT
//SORTIN DD DSN=ABC
//SORTOUT DD DSN=DEF
//SORTXSUM DD DSN=XYZ
//SYSIN DD *
SORT FIELDS=(5,18,CH,A)
SUM FIELDS=NONE,XSUM
/*
//SYSOUT DD SYSOUT=*
|
|
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
DFSORT does NOT support XSUM, but it can do the same thing with the SELECT operator of ICETOOL. The DFSORT/ICETOOL job would be:
| Code: |
//STEP04 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SORTIN DD DSN=ABC
//SORTOUT DD DSN=DEF
//SORTXSUM DD DSN=XYZ
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(5,18,CH) FIRST DISCARD(SORTXSUM)
/*
|
For more details, see the "Keep dropped duplicate records (XSUM)" Smart DFSORT Trick at:
Use [URL] BBCode for External Links |
|
| Back to top |
|
|
|
|
