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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm

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