Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
ark1208

New User

Joined: 01 Aug 2014
Posts: 1

 Posted: Fri Aug 01, 2014 4:13 pm    Post subject: Sort - sequence number by key Please do not tag onto a four year old topic. Start a new one. This has been split away from the original topic How do I get sequence numbers within a group key Input: aaaaaaa bbbbbbb bbbbbbb cccccccc ddddddd ddddddd ddddddd ddddddd eeeeeee eeeeeee eeeeeee Output: (Seq no should start from '1' when key changes) aaaaaaa 0001 bbbbbbb 0001 bbbbbbb 0002 cccccccc 0001 ddddddd 0001 ddddddd 0002 ddddddd 0003 ddddddd 0004 eeeeeee 0001 eeeeeee 0002 eeeeeee 0003

expat

Global Moderator

Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

Posted: Fri Aug 01, 2014 4:29 pm    Post subject:

1) As stated above - start a new topic.

2) Please use the SEARCH facility as this has been covered many times in the past for differing reasons.

3) Learn to use the code tags
 Code: [code]Your stuff goes here[/code]
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Fri Aug 01, 2014 4:41 pm    Post subject: Reply to: Sort - sequence number by key You go to the manual. You look in the index. You follow the references. You look to see that what you find does what you want. You code it and test it. You will find it also possible with WHEN=GROUP, but since you only want plain sequence numbers within a key, it will be more efficient the other way.
magesh23586

Active User

Joined: 06 Jul 2009
Posts: 213
Location: Chennai

Posted: Fri Aug 01, 2014 5:29 pm    Post subject:

Try this untested.

 Code: OPTION COPY                                      OUTREC FIELDS=(1,8,SEQNUM,4,ZD,RESTART=(1,7))

Hope this helps..
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

Posted: Fri Aug 01, 2014 6:41 pm    Post subject: Reply to: Sort - sequence number by key

magesh23586,

That's roughly what I was getting at.

I am going to start a "Fields Box". This is like a "Swear Box". Every time someone uses INREC FIELDS, OUTREC FIELDS or OUTFIL OUTREC, they have to contribute a small amount of currency to the "Fields Box".

Also, clearer (to me) to use OVERLAY to append data to a record:

 Code: OPTION COPY                                       INREC OVERLAY=(9:SEQNUM,4,ZD,RESTART=(1,7))
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Parsing more than 1000 columns in a s... ssuthagar SYNCSORT 10 Tue Sep 22, 2020 12:23 am SORT the records based on the second ... Ramsee SYNCSORT 1 Wed Aug 19, 2020 3:01 pm Required Date Format in Include Sort ... vivky_vivek DFSORT/ICETOOL 6 Fri Aug 14, 2020 6:52 am Populating Date and Sequence numer in... PORYES SYNCSORT 11 Thu Jul 16, 2020 5:01 pm Problem while trying to manipulate re... amitc23 DFSORT/ICETOOL 3 Tue Jun 30, 2020 1:19 pm

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us