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

JCL to extract repeating records
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
saikarthik94

New User


Joined: 04 Sep 2019
Posts: 12
Location: India
PostPosted: Mon Oct 05, 2020 8:05 pm
 Reply with quote
Hi,

I have a requirement like this -

1 ...
1 ...
1 ...
2 ...
3 ...
4 ...
4 ...
4 ...
4 ...
4 ...
5 ...

I need to extract those records which is repeating - ie my output should be-
1 ...
1 ...
1 ...
4 ...
4 ...
4 ...
4 ...
4 ...


I know i can use XSUM and join the file again to get the repeating data. But the files are too large and takes 30 to 45 mins to execute. Is there any way that can be performed in a single step or any command can be used to extract the repeating records ?
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland
PostPosted: Mon Oct 05, 2020 8:51 pm
 Reply with quote
Suggest you read up on ICETOOL's SELECT.... ALLDUPS.

Garry.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1245
Location: Bamberg, Germany
PostPosted: Tue Oct 06, 2020 12:53 am
 Reply with quote
saikarthik94 wrote:
I know i can use XSUM and join the file again to get the repeating data.

No, you can't.

From the manual: DFSORT does not support the XSUM parameter provided by a competitive sort product to write records
deleted by SUM processing to a SORTXSUM DD data set.

Topic should be moved to SYNCSORT section. icon_rolleyes.gif
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2018
Location: USA
PostPosted: Tue Oct 06, 2020 2:38 am
 Reply with quote
JCL has no abilities to perform ANY manipulations on data.
Nothing at all!
icon_pray.gif icon_axe.gif 12.gif 2020.gif
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1245
Location: Bamberg, Germany
PostPosted: Tue Oct 06, 2020 2:49 am
 Reply with quote
sergeyken wrote:
JCL has no abilities to perform ANY manipulations on data.
Nothing at all!
icon_pray.gif icon_axe.gif 12.gif 2020.gif

JCL has recently been upgraded to cater for all these Requirements. *cough*
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
PostPosted: Tue Oct 06, 2020 4:04 am
 Reply with quote
Please RTFM. Most of the times the same issues are discussed multiple times.
If you have a SYNCSORT then confirm so and then it can be moved to the right section.
e.g.
Split a file into unique vs duplicate records
XSUM Equivalent in DFSORT
DFSORT - Selecting Duplicate records
Back to top
View user's profile Send private message
saikarthik94

New User


Joined: 04 Sep 2019
Posts: 12
Location: India
PostPosted: Thu Oct 08, 2020 2:16 pm
 Reply with quote
Apologies for the delay in response -

Thanks Gary, i went thru ICETOOL ALLDUPS as you suggested and i got the result as desired.

Thanks ofr the suggestions - Joerg and sergenken.

Thanks Rohit, those links you provided are very helpful. Will try those.
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 -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us