View previous topic :: View next topic
|
Author |
Message |
suresh_gop
New User
Joined: 01 May 2005 Posts: 4 Location: india
|
|
|
|
Hi,
During sort i have eliminated duplicate records. but i want to get it now after sort. how? |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
I do not understand the question
Quote: |
but i want to get it now after sort. how? |
Can you please elaborate on this.
Gerry |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Go back to the original file.
There is nothing "to get" in the output from the process that eliminated the duplicates.
If the originial file has somehow been deleted, it will have to be re-created in order to get the duplicates. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Or is this in the context of XSUM..? |
|
Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005 Posts: 165 Location: Bangalore
|
|
|
|
Do you want to get the records which had the duplicate entries? |
|
Back to top |
|
|
sudhakar84
New User
Joined: 20 Jun 2008 Posts: 25 Location: chennai
|
|
|
|
Use XSUM function in sort
For example see the below given JCL,
//STEPSORT EXEC PGM=SORT
//SORTIN DD DISP=SHR,DSN=XXX.PV.SUMIN.SAMF
//SORTOF01 DD DISP=SHR,DSN=XXX.PV.SUMOUT.SAMF
//SORTXSUM DD DSN=XXX.PV.DUPLIC.SAMF,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(TRK,(50,50),RLSE),
// DCB=(RECFM=FB,LRECL=60,BLKSIZE=0)
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,1,CH,A)
OUTFIL FILES=01,INCLUDE=(6,6,CH,EQ,C' ')
SUM FIELDS=NONE,XSUM
/*
The file XXX.PV.DUPLIC.SAMF (SORTXSUM) will have the records which occured more than once. Its better u sort the file XXX.PV.DUPLIC.SAMF based on the entire record and remove the duplicates in it to get the clear picture. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
XSUM works during the sort - not after the sort as was requested in the original post. . . |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
suresh_gop,
Posting sample input/output records would definitely solve your problem.
Thanks,
Arun |
|
Back to top |
|
|
sudhakar84
New User
Joined: 20 Jun 2008 Posts: 25 Location: chennai
|
|
|
|
"Its better u sort the file XXX.PV.DUPLIC.SAMF based on the entire record and remove the duplicates in it to get the clear picture. "
This has to be done after getting the sortxsum output. then we will get the clear idea on the records which is having the duplicates.
dick scherrer wrote: |
Hello,
XSUM works during the sort - not after the sort as was requested in the original post. . . |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I have no idea what the previous reply is telling us. . .
d |
|
Back to top |
|
|
|