IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Having issues removing duplicates


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Sat Apr 26, 2014 4:01 pm
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Apr 26, 2014 5:10 pm
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
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: 156
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:33 pm
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: 156
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:35 pm
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: 156
Location: INDIA

PostPosted: Mon Apr 28, 2014 5:37 pm
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Apr 28, 2014 5:44 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3049
Location: NYC,USA

PostPosted: Tue Apr 29, 2014 3:33 am
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: 156
Location: INDIA

PostPosted: Tue Apr 29, 2014 12:25 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Issues with VIEW DATASET Command CLIST & REXX 2
No new posts How to remove block of duplicates DFSORT/ICETOOL 8
This topic is locked: you cannot edit posts or make replies. Compare files with duplicates in one ... DFSORT/ICETOOL 11
No new posts Issues with executing a REXX MACRO th... TSO/ISPF 4
No new posts Removing date values lines/records fr... SYNCSORT 2
Search our Forums:

Back to Top