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
 

 

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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Validating file with multiple header/... mohitsaini DFSORT/ICETOOL 6 Thu Apr 13, 2017 1:53 am
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am


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