IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

JCL to extract repeating records


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
saikarthik94

New User


Joined: 04 Sep 2019
Posts: 7
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: 1097
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

Active User


Joined: 15 Aug 2015
Posts: 352
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

Active Member


Joined: 29 Apr 2008
Posts: 879
Location: Maryland

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

Active User


Joined: 15 Aug 2015
Posts: 352
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: 2508
Location: NY,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: 7
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Inserting records into the empty segm... IMS DB/DC 0
No new posts Group selective VB records - Trailer ... DFSORT/ICETOOL 16
This topic is locked: you cannot edit posts or make replies. SORT the records based on the second ... SYNCSORT 1
No new posts to Insert Rows from File1 to File 2 ... DFSORT/ICETOOL 1
No new posts CA Sysview - JCL or Rexx - Read or Ex... CA Products 4

Back to Top