skip header records from input file

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

I have a sequential file from which I want to remove the header rows until I find a row with "MEMBER' . Is it anyways possible through sort or Icetool

Input file data :

Bill Woodger · Posted: Thu Mar 27, 2014 9:16 pm

Use IFTHEN=(WHEN=GROUP with BEGIN for "--MEMBERS--" and PUSH a character to an extension of the record.

In OUTFIL, use OMIT=/INLCUDE= to ignore/select your records, and BUILD to drop off the extension.

Pandora-Box · Posted: Thu Mar 27, 2014 9:59 pm

Instead of a sort step you can skip records in REXX in OUTTRAP while writing to output and thus you would retain only the member names.

Or In sort as the output is not going to change you could just SKIP the first 9 records

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

@Bill
I am not familiar with the syntax . Could you please elaborate more on how Rows after '--Member' can be included in the final file .

Thanks

Rohit Umarjikar · Posted: Fri Mar 28, 2014 4:24 am

Dilpreet,

Look at below thread, that would explain Bill's approach.

ibmmainframes.com/about55822.html

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

Thanks everyone. I was able to run the job using

//SYSIN DD *
OPTION COPY
INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,3,CH,EQ,C'--MEMBER'),PUSH=(81:3,6))
OUTFIL FNAMES=SORTOUT,INCLUDE=(81,6,CH,EQ,C'MEMBER'),BUILD=(1,80)