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
 
File Split

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Shriram Jogdand

New User


Joined: 14 Oct 2008
Posts: 65
Location: Pune

PostPosted: Fri May 02, 2014 12:57 am    Post subject: File Split
Reply with quote

I know that there are many topics on file split, but I didn't get the topic as per my requirement (or might got missed)

Here is the requirement:
I have file which I need to split in 2 files. There are different group of records which have HEADER and TRAILER for that group as shown below

HA This is Header of Type A records
10
10
10
20
30
40
70
T Trailer
HA This is Header of Type A records
10
10
10
20
30
40
70
T Trailer
HB This is Header of Type B records
10
30
40
70
T Triler

Here I want to split file in 2 files. First file should contain all records whose group have Header as Same (e.g HA) and other file which whose group have same header.

Output files
file-1

HA This is Header of Type A records
10
10
10
20
30
40
70
T Trailer
HA This is Header of Type A records
10
10
10
20
30
40
70
T Trailer

File-2

HB This is Header of Type B records
10
30
40
70
T Triler

Let me know if anything is required.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Fri May 02, 2014 2:07 am    Post subject: Reply to: File Split
Reply with quote

IFTHEN=(WHEN=GROUP on INREC with BEGIN for both the header types (an OR will be needed). PUSH the header type to a temporary extension to the record.

First OUTFIL with INCLUDE= for your HA in the extension to the record. BUILD= to return the record to original size.

Second OUTFIL, with SAVE, and identical BUILD= for same purpose.
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 File Aid tool to compare numeric data balaji81_k DFSORT/ICETOOL 0 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm

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