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
 

 

Getting previous record using SORT New

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

New User


Joined: 29 Jun 2010
Posts: 11
Location: chennai

PostPosted: Thu Jul 26, 2012 5:41 pm    Post subject: Hi All
Reply with quote

I am having a problem that is most similar to this.
input/output record lenght is 133.

Input looks like ----------------

columns - 123456789...............................
CCNA report 1 Date - rundate
xxxxx Page 1
Market id : AATS date
cuid:CCSC
record1
record2
...........
recordn
CCNA report 1 Date - rundate
xxxxx Page 2
Market id : AAQS date
cuid:CCSC
record1
record2
...........
recordn
CCNA report 1 Date - rundate
xxxxx Page - 3
Market id : AAPS date
cuid:CCUC
record1
record2
...........
recordn
there can be n no of total records.also lines in each group are not fixed

I want to split this report into two files.
based on cuid
there are only two cuid in the files -CCUC and CCSC
File1- having record for cuid CCSC
File2- having record for cuid CCUC

Output file 1
123456789...............................
CCNA report 1 Date - rundate
xxxxx Page 1
Market id : AATS date
cuid:CCSC
record1
record2
...........
recordn
CCNA report 1 Date - rundate
xxxxx Page 2
Market id : AAQS date
cuid:CCSC
record1
record2
...........
recordn


Output file 2
CCNA report 1 Date - rundate
xxxxx Page - 1
Market id : AAPS date
cuid:CCUC
record1
record2
...........
recordn
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Thu Jul 26, 2012 6:10 pm    Post subject: Reply to: Getting previous record using SORT New
Reply with quote

Thanks Peter.

sanupadh,

You've made a real mess of this so far. Multiple posts. Tailgating an old topic. Not using the Code tags. Soliciting responses.

Please, a new topic for a new question (you can refer to other information here with a URL link). Don't post multiple times. Use the Code tags to preserve spacing and make any data/code easier to read. Don't prompt for help if you don't get an answer within moments, unless you are intending paying someone to give you the answer.
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 Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
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


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