|
|
| Author |
Message |
Tarun Deep
Warnings : 1
New User
Joined: 10 Jun 2005
Posts: 10
Location: Hyderabad, India
|
|
|
|
Hi All
Please help me by providing the solution to the following problem.
My Input file looks like this -
AAA RECORD 1
BBB RECORD 1
BBB RECORD 2
CCC RECORD 1
DDD RECORD 1
DDD RECORD 2
DDD RECORD 3
DDD RECORD 4
EEE RECORD 1
FFF RECORD 1
GGG RECORD 1
Output file should contain only the duplicate records as following :
BBB RECORD 1
BBB RECORD 2
DDD RECORD 1
DDD RECORD 2
DDD RECORD 3
DDD RECORD 4
i.e. - I do not want those records in output file which have single entries in input file.
Please provide the syntax for this at the earliest.
Thanks in advance 
Tarun |
|
| Back to top |
|
 |
References
|
 Posted: Fri Jun 10, 2005 1:54 pm Post subject: Re: JCL Syntex reqd to get only duplicate records from a file |
|
|
|
|
sangiah
Active User
Joined: 10 Jun 2005
Posts: 62
|
|
|
|
| you may check ICETOOL |
|
| Back to top |
|
|
Alain Benveniste
Active User
Joined: 14 Feb 2005
Posts: 89
|
|
|
|
Tarun,
Here is a DFSORT/ICETOOL job that does want you want
| Code: |
//STEP0001 EXEC PGM=ICETOOL
//DFSMSG DD SYSOUT=*
//TOOLMSG DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUTX) ON(1,3,CH) ALLDUPS
/*
//OUTX DD DSN=... output file
//IN DD *
AAA RECORD 1
BBB RECORD 1
BBB RECORD 2
CCC RECORD 1
DDD RECORD 1
DDD RECORD 2
DDD RECORD 3
DDD RECORD 4
EEE RECORD 1
FFF RECORD 1
GGG RECORD 1
/*
|
Alain |
|
| Back to top |
|
|
Tarun Deep
Warnings : 1
New User
Joined: 10 Jun 2005
Posts: 10
Location: Hyderabad, India
|
|
|
|
Thanks a lot Alain !!
It worked absolutely fine.  |
|
| Back to top |
|
|
|
|
