Insert required fields in selected records of flat file

srikar tenali · New User Joined: 07 Feb 2007 Posts: 22 Location: hyderabad

Input File :
HEADER ROW LOAD DATA LOG NO
DATA ROW ABCD_TABLE NAME 1
DATA ROW ABCD_TABLE NAME 2
..............
...........
TRAILER ROW LOAD DATA LOG NO

Output file:
HEADER ROW LOAD DATA RESUNE YES LOG NO
DATA ROW ABXY_TABLE NAME 1
DATA ROW ABCD_TABLE NAME 2
..............
...........
TRAILER ROW LOAD DATA LOG NO

The changes are required only in the first two lines of the flatfile i.e. the header row where 'RESUME YES' needs to be inserted after 'LOAD DATA', and the first Data row where 'ABCD' needs to be converted into 'ABXY'.
File can have any number of records.
Rest all records needs to be unchanged.
Can we use DFSORT facility in reaching this result??

thanks in Advance for the replies.

Frank Yaeger · Posted: Mon Apr 21, 2008 9:44 pm

Here's a DFSORT job that will do what you asked for. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.