Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Having issues removing duplicates

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Sat Apr 26, 2014 4:01 pm    Post subject: Having issues removing duplicates
Reply with quote

Hi All,

PLease help me in below scenario

My Input is like below

Code:
/LIST ID=04DAC  GEN=*
/LIST ID=EED83  GEN=*
/LIST ID=04DAC  GEN=*
/LIST ID=EED83  GEN=*
/LIST ID=21DEC  GEN=*
/LIST ID=19DPC  GEN=*
/LIST ID=DDD08  GEN=*
/LIST ID=DDD08  GEN=*
/LIST ID=86DPC  GEN=*
/LIST ID=86DPC  GEN=*
/LIST ID=DDD09  GEN=*
/LIST ID=DDD09  GEN=*
/LIST ID=22DPC  GEN=*
/LIST ID=22DPC  GEN=*
/LIST ID=DDD07  GEN=*
/LIST ID=DDD07  GEN=*
/LIST ID=JJD62  GEN=*
/LIST ID=JJD62  GEN=*
/LIST ID=DDD10  GEN=*
/LIST ID=DDD10  GEN=*


Using Sort control card like below

Code:
SORT FIELDS=(1,14,CH,A)
SUM FIELDS=NONE,XSUM



Below is the output which I am getting

Code:
/LIST ID=REPDDD08  GEN=*
/LIST ID=EED83  GEN=*
/LIST ID=JJD62  GEN=*
/LIST ID=04DAC  GEN=*
/LIST ID=19DPC  GEN=*
/LIST ID=21DEC  GEN=*
/LIST ID=22DPC  GEN=*
/LIST ID=86DPC  GEN=*



While I am expecting the output like below

Code:
/LIST ID=REP04DAC  GEN=*
/LIST ID=EED83  GEN=*
/LIST ID=04DAC  GEN=*
/LIST ID=21DEC  GEN=*
/LIST ID=19DPC  GEN=*
/LIST ID=DDD08  GEN=*
/LIST ID=86DPC  GEN=*
/LIST ID=DDD09  GEN=*
/LIST ID=22DPC  GEN=*
/LIST ID=DDD07  GEN=*
/LIST ID=JJD62  GEN=*
/LIST ID=DDD10  GEN=*



Please help to identify whre I am making a mistake
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Sat Apr 26, 2014 5:10 pm    Post subject: Reply to: Having issues inremoving duplicates
Reply with quote

Please show the sysout from your step. Why were you expecting that output?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Apr 26, 2014 8:16 pm    Post subject:
Reply with quote

considering that this:
Code:
/LIST ID=REPDDD08  GEN=*

from the actual output
nor this:
Code:
/LIST ID=REP04DAC  GEN=*

from your expect output

do not exsist in the input provided

makes it hard, even on a Saturday, to take this sillliness seriously.
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:33 pm    Post subject:
Reply with quote

I am sorry for my bad

Peasae see below the exact input and output .. I removed the REP from the job names but few of them left by mistake

Input
Code:
/LIST ID=REP04DAC  GEN=*
/LIST ID=REPEED83  GEN=*
/LIST ID=REP04DAC  GEN=*
/LIST ID=REPEED83  GEN=*
/LIST ID=REP21DEC  GEN=*
/LIST ID=REP19DPC  GEN=*
/LIST ID=REPDDD08  GEN=*
/LIST ID=REPDDD08  GEN=*
/LIST ID=REP86DPC  GEN=*
/LIST ID=REP86DPC  GEN=*
/LIST ID=REPDDD09  GEN=*
/LIST ID=REPDDD09  GEN=*
/LIST ID=REP22DPC  GEN=*
/LIST ID=REP22DPC  GEN=*
/LIST ID=REPDDD07  GEN=*
/LIST ID=REPDDD07  GEN=*
/LIST ID=REPJJD62  GEN=*
/LIST ID=REPJJD62  GEN=*
/LIST ID=REPDDD10  GEN=*
/LIST ID=REPDDD10  GEN=*


OutPut

Code:
/LIST ID=REPDDD08  GEN=*
/LIST ID=REPEED83  GEN=*
/LIST ID=REPJJD62  GEN=*
/LIST ID=REP04DAC  GEN=*
/LIST ID=REP19DPC  GEN=*
/LIST ID=REP21DEC  GEN=*
/LIST ID=REP22DPC  GEN=*
/LIST ID=REP86DPC  GEN=*


I am wondering that why
Code:
REPDDD10
and
Code:
REPDDD07
are not included in the output.
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:35 pm    Post subject:
Reply with quote

even
Code:
REPDDD09
is also not included
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:37 pm    Post subject:
Reply with quote

When I sorted like below

Code:
SORT FIELDS=(10,08,CH,A)
SUM FIELDS=NONE,XSUM 


Then I got all of them icon_smile.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Mon Apr 28, 2014 5:44 pm    Post subject: Reply to: Having issues removing duplicates
Reply with quote

Because previously you were only sorting on the first six characters of the "jobname", and only the first six would count for the "de-duplication".
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Apr 29, 2014 3:33 am    Post subject:
Reply with quote

Sumit,

You need to check what values are present on 6th byte make a hex on and show us.
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue Apr 29, 2014 12:25 pm    Post subject:
Reply with quote

HI Rohit,

Its a space(X'40') only .. I checked it

/
Code:
LIST ID=REP04DAC  GEN=*
6DCEE4CC7DCDFFCCC44CCD75
13923094E9570441300755EC
------------------------
/LIST ID=REPEED83  GEN=*
6DCEE4CC7DCDCCCFF44CCD75
13923094E9575548300755EC
------------------------
/LIST ID=REP04DAC  GEN=*
6DCEE4CC7DCDFFCCC44CCD75
13923094E9570441300755EC
------------------------
/LIST ID=REPEED83  GEN=*
6DCEE4CC7DCDCCCFF44CCD75

Please take a look above.. However My issue got resolved now as I stated in my previous step icon_smile.gif

Thanks Much!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 1 Fri Dec 09, 2016 4:40 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Removing Extra Spaces in a comma sepa... Puspojit DFSORT/ICETOOL 3 Tue Sep 13, 2016 7:46 am
No new posts Faccing issues while creating a GDG V... sravindra_s JCL & VSAM 5 Thu Jun 23, 2016 11:26 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us