|
View previous topic :: View next topic
|
| Author |
Message |
kedianirmal
New User
.jpg)
Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India
|
|
|
|
Hi,
I have to sort a file based on one key and remove the duplicated using another key.
First sort the file using the below key:
| Code: |
| SORT FIELDS=(1,15,CH,A,26,4,CH,A,23,2,CH,A,20,2,CH,A) |
Then remove the duplicate records using the below key:
| Code: |
SORT FIELDS=(1,15,CH,A)
SUM FIELDS=NONE |
I can acheive this using two steps in JCL, but i was looking if both the things are possible in single JCL step.
Please Help, Thanks
Nirmal |
|
| Back to top |
|
 |
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
kedarinirmal,
Assuming you input has an lrecl of 80 bytes and is of FB recfm , use the following control cards which will give you the desired results
| Code: |
//SYSIN DD *
SORT FIELDS=(1,15,CH,A,26,4,CH,A,23,2,CH,A,20,2,CH,A),EQUALS
OUTFIL REMOVECC,NODETAIL,SECTIONS=(1,15,HEADER3=(1,80))
/* |
|
|
| Back to top |
|
|
kedianirmal
New User
Joined: 08 Feb 2008
Posts: 82
Location: Bangalore, India
|
|
|
|
Thanks a lot,
Its working fine.... |
|
| Back to top |
|
|
|
|
|
