File Split

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.

Bill Woodger · Posted: Fri May 02, 2014 2:07 am

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.