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

Create Group Headers


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

New User


Joined: 30 Sep 2006
Posts: 60

PostPosted: Wed May 11, 2011 2:15 pm
Reply with quote

Hi,

I have a file with length 80 and format FB - with a counter of 3 bytes in positions 1-3, followed by a space, followed by a identifier string of 2 byte character data.

Input file

001 AA
002 AA
003 AA
001 BB
009 BB
005 CC
007 CC

I need to create an output file such that the identifier string gets written as a header record for the group of records. So, the output will be:

AA
001
002
003
BB
001
009
CC
005
007

Can thiis be done using sort?

Thanks,
Aneesh.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 11, 2011 4:02 pm
Reply with quote

Below step will give required output...

Code:

//STEP10   EXEC PGM=SORT                                           
//SORTIN       DD *                                                 
001 AA                                                             
002 AA                                                             
003 AA                                                             
001 BB                                                             
009 BB                                                             
005 CC                                                             
007 CC                                                             
/*                                                                 
//SORTOUT DD SYSOUT=*                                               
//SYSOUT  DD SYSOUT=*                                               
//SYSIN    DD  *                                                   
  SORT FIELDS=(5,2,CH,A)                                           
  OUTFIL REMOVECC,SECTIONS=(5,2,HEADER3=(5,2,80:X)),BUILD=(1,3,80:X)
/*                                                                 


Output,
Code:
AA 
001
002
003
BB 
001
009
CC 
005
007
Back to top
View user's profile Send private message
Aneesh

New User


Joined: 30 Sep 2006
Posts: 60

PostPosted: Wed May 11, 2011 4:13 pm
Reply with quote

Thanks a lot icon_smile.gif
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 11, 2011 4:26 pm
Reply with quote

Aneesh wrote:
Thanks a lot icon_smile.gif

Cheers... icon_smile.gif
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

 


Similar Topics
Topic Forum Replies
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Grouping by multiple headers DFSORT/ICETOOL 7
No new posts Compare latest 2 rows of a table usin... DB2 1
No new posts create rexx edit Macro that edits the... CLIST & REXX 3
No new posts COBOL - create and write to output fi... COBOL Programming 0
Search our Forums:

Back to Top