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
 

 

Syncsort duplicate filter

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
subbuy2k

New User


Joined: 17 Apr 2009
Posts: 8
Location: milford

PostPosted: Thu Apr 22, 2010 8:23 pm    Post subject: Syncsort duplicate filter
Reply with quote

Hi,
I have records coming from 3 different states(NY,NJ,CT). If the customer # is part of all three states then in output file i have to write only the NY record. If not i have to write the other two states.Can we do this in syncsort. I dont want to do this in cobol pgm or icetool.

example
INPUT
========
1111111 NY
1111111 NJ
1111111 CT
2222222 NJ
2222222 NY
3333333 NJ
3333333 CT

OUTPUT
-----------
1111111 NY
2222222 NJ
2222222 NY
3333333 NJ
3333333 CT
__________________
Thanks
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Apr 22, 2010 9:16 pm    Post subject:
Reply with quote

Your description does not match with your example, as far as I understand. Your description says:
Quote:
If the customer # is part of all three states then in output file i have to write only the NY record.
then for this input
Quote:
2222222 NJ
2222222 NY
why do you have this
Quote:
2222222 NJ
2222222 NY
as output, it should have been
Quote:
2222222 NY
?
Back to top
View user's profile Send private message
subbuy2k

New User


Joined: 17 Apr 2009
Posts: 8
Location: milford

PostPosted: Thu Apr 22, 2010 9:24 pm    Post subject:
Reply with quote

2222222 is not part of 3 states. Its part of NY and NJ not part of CT. So we need both.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Sat Apr 24, 2010 2:58 am    Post subject:
Reply with quote

subbuy2K,

Please do not post the same question in multiple forums. This question has already been addressed in the other forum. Therefore, I am locking this thread. If you have any further questions regarding this issue, please post where the solution was provided. Thank you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 5 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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