Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Remove selected duplicate rows from the PS file using SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
hnharish

New User


Joined: 30 Aug 2005
Posts: 23

PostPosted: Wed Sep 05, 2018 3:11 am    Post subject: Remove selected duplicate rows from the PS file using SORT
Reply with quote

Need help.
I need to remove only selected duplicate rows from the PS file using SORT JCL. In the below example, need to remove duplicates only for AAA and DDD. The BBB shouldn't be touched. Please tell me if it can done in single SORT step.

Input File:
AAA
AAA
BBB
BBB
DDD
DDD

Output File:
AAA
BBB
BBB
DDD
Back to top
View user's profile Send private message

Arun Raj

Moderator


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

PostPosted: Wed Sep 05, 2018 3:49 am    Post subject:
Reply with quote

How do you select AAA or DDD? Can it be something else.? What about the input RECFM LRECL etc.

You have been here long enough to learn to use Code tags. It may not matter to the above sample data posted, please keep it in mind for your future posts that include code or data.
You might want to give another try at explaining what are you trying to achieve to get useful responses. Good luck.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Wed Sep 05, 2018 4:14 am    Post subject:
Reply with quote

Why do you think this link won’t help getting you direction to solve your problem? You need to do research basically to get to the same/similar post which has been already discussed in past and this being the most recent one.

http://ibmmainframes.com/viewtopic.php?p=344806#344806

Quote:
Please tell me if it can done in single SORT step
if you tried and got the solution in more than one step then show us what you tried to know if it can be done in one step.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2110
Location: UK

PostPosted: Wed Sep 05, 2018 2:18 pm    Post subject: Reply to: Remove selected duplicate rows from the PS file using SORT
Reply with quote

You can not do it with "sort JCL". JCL does not manipulate data. It tells the operating system what programs you want executed and the resources required. You should know that after at least 13 years in the business and you should know that the correc terminology is control statements. (No need to mention sort as you posted in the a Sort forum.)
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Will this code extract 1 byte from fi... pkmurali CLIST & REXX 8 Sat Nov 10, 2018 11:13 pm
No new posts Error reading file in REXX module ashek15 CLIST & REXX 3 Wed Oct 24, 2018 4:50 am
No new posts Convert VB file to FB plus special fo... cz016m SYNCSORT 15 Fri Oct 19, 2018 7:26 pm
No new posts Picking up the latest PS file pema_yozer JCL & VSAM 8 Thu Oct 11, 2018 12:26 pm
No new posts Process only last key record in a fil... Naveen.katkuri24 DFSORT/ICETOOL 8 Tue Oct 09, 2018 9:39 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us