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
 

 

Using ICETOOL, how we can seperate the duplicate and non dup

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
bshkris

New User


Joined: 21 Mar 2005
Posts: 29
Location: pune

PostPosted: Tue May 09, 2017 8:33 pm    Post subject: Using ICETOOL, how we can seperate the duplicate and non dup
Reply with quote

Hello,
I need some idea how can separate dup and non dup records separately..
either by using ICETOOL or SORT.

Input file
----------
2017-05-240001000002400
2017-04-020001000002600
2017-04-020001000002600
2017-04-260001000004400
2017-05-250001000002400
2017-05-240001000002400

OutFile1:
----------
2017-05-240001000002400
2017-05-250001000002400
2017-05-240001000002400

Outfile2:
--------
2017-04-020001000002600
2017-04-020001000002600
2017-04-260001000004400


Read more: http://ibmmainframes.com/viewtopic.php?p=339983#339983#ixzz4gatcM4Jb
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Tue May 09, 2017 8:37 pm    Post subject:
Reply with quote

Key position and length is important in doing this, which is missing here.

In general, the ICETOOL SELECT operator with NODUPS/ALLDUPS along with a DISCARD dd should do this.

Your recent posts indicate that you are using Syncsort and NOT DFSORT.
This has already been brought to your attention by Robert in the other topic.

Please start paying attention to the questions/suggestions made by others, and make sure you post your new sort-related topics in the Syncsort forum, going forward. If you have a totally different requirement, always start a new topic rather than continuing on a solved topic.
Back to top
View user's profile Send private message
bshkris

New User


Joined: 21 Mar 2005
Posts: 29
Location: pune

PostPosted: Tue May 09, 2017 9:51 pm    Post subject:
Reply with quote

I have issue with dates, like when I have records in same month more than 1, example

case1:
2017-05-240001000002400
2017-05-250001000002400
2017-05-240001000002400

all above records should go in out put file 1.


case 2: if only two records comes in input file
2017-05-240001000002400
2017-05-240001000002400

only one rec I need to put in out put file 2

should go another file

Tried many ways, not happening.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Tue May 09, 2017 10:14 pm    Post subject:
Reply with quote

You should be posting it under Beginner's forum henceforth.
Quote:
Tried many ways, not happening.
Except doing research on internet, Here is exactly what is being discussed in past which I found in 2 minutes over the same internet.
http://www.ibmmainframeforum.com/syncsort-synctool/topic3173.html
http://www.ibmmainframeforum.com/dfsort-icetool-icegener/topic2238.html
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Tue May 09, 2017 10:40 pm    Post subject:
Reply with quote

bshkris,

It is not so clear (at least to me) what you are trying to do.
For the sample input shown in the original post, can you explain how you arrived at the expected output.
Back to top
View user's profile Send private message
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 200
Location: USA

PostPosted: Tue May 09, 2017 10:55 pm    Post subject:
Reply with quote

Yeah, this is bit confusing without key and real expected output details. Based on his second post 'perhaps' this is the expectation, not sure(The TS needs to confirm).

1. Group the input records by Month first.
2. Check if all the records in that 'Month group' are of same date. If yes, remove all the dups and return one(Again, which one to return??). If not of same date, copy all the input records to output.
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm


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