nagarajan.dharani
New User
Joined: 27 Dec 2006 Posts: 36 Location: Chennai
|
|
|
|
Hi,
Could someone help me with the following requirement.
I've a sequential with the records as below
Code: |
Emp-no Emp-type PRM-IND
000000001 CL Y
000000001 CL N
000000001 CL N
000000001 CL N
000000001 CL N
000000002 CL Y
000000002 CL Y
000000003 CL N
000000004 CL Y
000000005 CL Y
000000005 CL Y
|
The requirement is to select the records which are duplicates on the combination of Emp-no and Emp-type
My output should look like
Code: |
000000001 CL Y
000000001 CL N
000000001 CL N
000000001 CL N
000000001 CL N
000000002 CL Y
000000002 CL Y
000000005 CL Y
000000005 CL Y
|
Is there any possibility to do this using DFSORT/ICETOOL
Thanks,
Dharani |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here's a DFSORT/ICETOOL job that will do what you asked for:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,9,CH) ON(33,2,CH) ALLDUPS
/*
|
|
|