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: 7254

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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts How to get previous month in SYMNAMES Suganya87 SYNCSORT 9 Fri Oct 28, 2016 1:37 pm


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