Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Apply Header for every 1500 records.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Apr 10, 2009 12:06 am    Post subject: Apply Header for every 1500 records.
Reply with quote

Hi, We have two files.

File-1:
Code:

----+----1----+----2
RUMBAYR08D123
RUMBAYR09D198
RUMBAYR10D233


File-2:
Code:

----+----1----+----2----+----3
ABCD1111 265 1012008
ABCD1111   5 2012008
ABCD2111 365 1012008
ABCD2111   5 2012008
ABCD1112 265 1012009
ABCD1112   5 2012009
ABCD1113 265 1012009
ABCD1113   5 2012009
ABCD1114 265 1012010
ABCD1114   5 2012010


I want the output in the below format:

Output:
Code:

----+----1----+----2----+----3
     RUMBA0800123
ABCD1111 265 1012008
ABCD1111   5 2012008
ABCD2111 365 1012008
ABCD2111   5 2012008
     RUMBA0900198
ABCD1112 265 1012009
ABCD1112   5 2012009
ABCD1113 265 1012009
ABCD1113   5 2012009
     RUMBA1000233
ABCD1114 265 1012010
ABCD1114   5 2012010


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

ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Apr 10, 2009 12:08 am    Post subject: sorry
Reply with quote

Sorry, I hit the submit button instead of preview button icon_redface.gif
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Fri Apr 10, 2009 12:14 am    Post subject:
Reply with quote

The additional requirement is to increment the number (11th column in File-1) by one (if '101' type records at 19 column in File-2 are equal to 1500) and write a seperate header followed by records as shown below:

Code:

----+----1----+----2----+----3
     RUMBA0800124
ABCD1111 265 1012008
ABCD1111   5 2012008
ABCD2111 365 1012008
ABCD2111   5 2012008


This is same for the 09 & 10 also. Please let me know if my requirement is clear.

Thanks.
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Fri Apr 10, 2009 7:35 pm    Post subject:
Reply with quote

I think this can be done thru COBOL program.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Skip records depends on count lakshmiibmmainframes DFSORT/ICETOOL 5 Sun Dec 24, 2017 9:51 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 9 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us