View previous topic :: View next topic
|
Author |
Message |
Shriram Jogdand
New User
Joined: 14 Oct 2008 Posts: 65 Location: Pune
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|