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
 

 

How to increase seqnum in the sort

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

New User


Joined: 14 Aug 2006
Posts: 8

PostPosted: Wed Feb 06, 2008 3:46 pm    Post subject: How to increase seqnum in the sort
Reply with quote

I want to break the records

CAS093000100 03$001043
CAS093000200 03$999000
CAS093000300 03$001043
CAS093000400 03$360999

in the following format

CAS093197101 03$001
CAS093197102 03$043

when 999 is found in the data after $ I want the field from 7 byte to 10 byte to increment by one ie 1972. This 1972 should be applicable from next record output,the data after $ part should come in outrec with three byte in each output record.

Ie the output of next record should be

CAS093197201 03$001
CAS093197202 03$043
CAS093197202 03$360
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Feb 06, 2008 8:37 pm    Post subject:
Reply with quote

himant,

Either your explanation is not enough or your requirement is confusing.

Put more examples with lots and lots of explanation (like from where did you get 1971 and 1972? etc....)
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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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