View previous topic :: View next topic
|
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 |
|
|
sangiah
New User
Joined: 10 Jun 2005 Posts: 62
|
|
|
|
you may check ICETOOL |
|
Back to top |
|
|
Alain Benveniste
New User
Joined: 14 Feb 2005 Posts: 88
|
|
|
|
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 |
|
|
|