View previous topic :: View next topic
|
Author |
Message |
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Please show the sysout from your step. Why were you expecting that output? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
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
and
are not included in the output. |
|
Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
even
is also not included |
|
Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
When I sorted like below
Code: |
SORT FIELDS=(10,08,CH,A)
SUM FIELDS=NONE,XSUM |
Then I got all of them |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
|
|
Sumit,
You need to check what values are present on 6th byte make a hex on and show us. |
|
Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013 Posts: 156 Location: INDIA
|
|
|
|
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
Thanks Much!! |
|
Back to top |
|
|
|