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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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