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

SORT the records based on the second word


IBM Mainframe Forums -> SYNCSORT
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
Ramsee

New User


Joined: 06 Jan 2011
Posts: 53
Location: Chennai

PostPosted: Wed Aug 19, 2020 3:01 pm
Reply with quote

I need a help to sort the fields based on the second word of the records,

Input:

ACHIEVEMENT UNIQUE
ACHIEVEMENT UNIQUE
ACHIEVEMENT UNIQUE1
ABC CORP
BELL LAB
BELL LAB
BELL INC
BELL CORP

Output:
ACHIEVEMENT UNIQUE
ACHIEVEMENT UNIQUE1
ABC CORP
BELL LAB
BELL INC
BELL CORP

Here the sort is based on the first word is unique or not, if the first word is unique then we need to compare the next word, if the second word is unique we need to write in the output file, if the second word is not unique we will exclude, there is not size limit for the first and second word.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Aug 19, 2020 5:13 pm
Reply with quote

Already posted in the beginners forum under dfsort. Cross-posting is not going to help you. Topic locked.
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
Search our Forums:

Back to Top