View previous topic :: View next topic |
Author |
Message |
Milind Beginner
Joined: 29 Dec 2004 Posts: 26 Topics: 20
|
Posted: Mon Jul 04, 2005 11:14 pm Post subject: How to get duplicate records in output dataset using DFSORT |
|
|
Hi,
I have an input as follws:
12
34
56
12
12
67
12
34
In the output dataset I want only duplicate records as :
12
34
12
12
12
34.
OR:
12
12
12
12
34
34
Is this possible using DFSORT?
Experts please help...
Thansk and Regards,
Milind Deshmukh. |
|
Back to top |
|
 |
Ram Beginner

Joined: 12 Jan 2004 Posts: 53 Topics: 12
|
Posted: Tue Jul 05, 2005 1:40 am Post subject: |
|
|
Milind,
The below DFSORT/ICETOOL JCL will give you the desired results.
Code: |
//STEP001 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//INPUT DD *
12
34
56
12
12
67
12
34
/*
//OUTPUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(INPUT) TO(OUTPUT) ON(1,2,CH) ALLDUPS
/*
|
Thanks,
Ram |
|
Back to top |
|
 |
Milind Beginner
Joined: 29 Dec 2004 Posts: 26 Topics: 20
|
Posted: Tue Jul 05, 2005 4:16 am Post subject: |
|
|
Thanks Ram for your quick reply
Regards,
Milind Deshmukh. |
|
Back to top |
|
 |
|
|