|
View previous topic :: View next topic
|
| Author |
Message |
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Hi,
Can you please help me to find matching entries written to SORTOUT for all the duplicates written to SORTXSUM.
INPUT FILE - LRECL=30, RECFM=FB
| Code: |
----+----1----+----2----+----3
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD6 FROM FILE8 OF 10-01-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD2 FROM FILE5 OF 08-09-13
|
SORTOUT:-
| Code: |
RECORD1 FROM FILE1 OF 20-10-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD2 FROM FILE5 OF 08-09-13
RECORD6 FROM FILE8 OF 10-01-13
|
SORTXSUM:-
| Code: |
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD8 FROM FILE4 OF 16-06-13
|
Expected SORTOF1:- This should have matching entries from SORTOUT for match found from SORTXSUM
| Code: |
RECORD1 FROM FILE1 OF 20-10-13
RECORD8 FROM FILE4 OF 16-06-13
|
Expected SORTOF2:- This should have remaining entries from SORTOUT
| Code: |
RECORD2 FROM FILE5 OF 08-09-13
RECORD6 FROM FILE8 OF 10-01-13
|
My SORT job:-
| Code: |
//SORT01 EXEC PGM=SORT
//SORTIN DD *
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD6 FROM FILE8 OF 10-01-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD2 FROM FILE5 OF 08-09-13
//SORTOUT DD SYSOUT=*
//SORTXSUM DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,6,CH,A,14,5,CH,A,23,8,CH,A)
SUM FIELDS=NONE,XSUM
|
Please help. |
|
| Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
What kind of requirement is this?
and what have you tried and what is stopping you?
and All you need is just another step with JOINKEYS to achieve the result needed
Edit: You might also eed unique data in SORTXSUM dataset |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
try this
| Code: |
//STEP0001 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD1 FROM FILE1 OF 20-10-13
RECORD6 FROM FILE8 OF 10-01-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD8 FROM FILE4 OF 16-06-13
RECORD2 FROM FILE5 OF 08-09-13
//T1 DD DSN=&&T1,DISP=(,PASS,DELETE),UNIT=SYSDA,
// SPACE=(TRK,(10,5),RLSE)
//OUT1 DD SYSOUT=*
//OUT2 DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT1) ON(1,7,CH) ON(14,5,CH) ON(23,8,CH) -
NODUPS DISCARD(T1)
SELECT FROM(T1) TO(OUT2) ON(1,7,CH) ON(14,5,CH) ON(23,8,CH) -
FIRSTDUP
|
Gerry |
|
| Back to top |
|
|
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
| Pandora, thanks for the idea. |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Ramsri,
You should look at Gicchet's post aswell |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Ramsri,
New avatar, but not much else changes.
Have you looked at using DUPKEYS instead of SUM, if your SyncSort has it?
If you don't have DUPKEYS, tell us what you want to achieve and show your existing step. Don't just ask us how to implement the method that you think should be used. Without DUPKEYS, it is likely that SyncTool will be a better shot at what you want, be we can't really tell. |
|
| Back to top |
|
|
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Haven't tried DUPKEYS......will try and post it here.
Thanks. |
|
| Back to top |
|
|
|
|
