|
|
| Author |
Message |
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 124
Location: trichy
|
|
|
|
INPUT:
| Code: |
WDCP TR WDCP WDCP ID
ID SSN NOD ID GUAR AGCY
C 9 N 3 C 3
15------- 24---- 27-------
310789954 004 836
312520249 002 836
312929875 002 836
325807809 003 836
325807809 002 836
242293732 001 836
242293732 001 836
242293732 001 836
242293732 001 836
346685284 001 836
378920533 001 836
378920533 001 836
413963981 003 836
413963981 003 836
433679765 004 836 |
REQUIRED OUTPUT:
| Code: |
WDCP TR WDCP WDCP ID
ID SSN NOD ID GUAR AGCY
C 9 N 3 C 3
15------- 24---- 27-------
242293732 001 836
242293732 001 836
242293732 001 836
242293732 001 836
378920533 001 836
378920533 001 836
413963981 003 836
413963981 003 836 |
I want only the records where the SSN and NOD ID field combinely occurs
more than one times.
I tried the XSUM option, but the output i got was,
| Code: |
WDCP TR WDCP WDCP ID
ID SSN NOD ID GUAR AGCY
C 9 N 3 C 3
15------- 24---- 27-------
242293732 001 836
242293732 001 836
242293732 001 836
378920533 001 836
413963981 003 836 |
Anybody please help me how to get the required output.
Regards
R KARTHIK |
|
| Back to top |
|
 |
References
|
 Posted: Wed May 14, 2008 12:29 pm Post subject: Re: How to code the following requirement? |
|
|
|
|
krisprems
Senior Member
Joined: 27 Nov 2006
Posts: 626
Location: India
|
|
|
|
You can use the below SYNCTOOL solution for your problem:
| Code: |
//**********************************************
//GETMATCH EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
310789954 004 836
312520249 002 836
312929875 002 836
325807809 003 836
325807809 002 836
242293732 001 836
242293732 001 836
242293732 001 836
242293732 001 836
346685284 001 836
378920533 001 836
378920533 001 836
413963981 003 836
413963981 003 836
433679765 004 836
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,13,CH) ALLDUPS
/*
//* |
OUT will contain the req o/p |
|
| Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 124
Location: trichy
|
|
|
|
Hi krisprems,
Thanks for ur immediate help.
It's working now.
Regards
R KARTHIK. |
|
| Back to top |
|
|
| Moved: Wed May 14, 2008 8:56 pm by Frank Yaeger From DFSORT/ICETOOL to JCL |
|
|
