IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

skip header records from input file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dilpreet

New User


Joined: 18 Mar 2008
Posts: 34
Location: INDIA

PostPosted: Thu Mar 27, 2014 9:07 pm
Reply with quote

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 :

Code:
 READY
   LISTDS 'C8AYPE.LOADLIB.C82PROD.ANNO' MEMBERS
 C8AYPE.LOADLIB.C82PROD.ANNO
 --RECFM-LRECL-BLKSIZE-DSORG
   U     **    13030   PO

 --VOLUMES--
   M93855
 --MEMBERS--                              --> want to skip records till here
   ALCICWI6
   ALCICWI7


Code'd
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Thu Mar 27, 2014 9:16 pm
Reply with quote

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.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1586
Location: Andromeda Galaxy

PostPosted: Thu Mar 27, 2014 9:59 pm
Reply with quote

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
Back to top
View user's profile Send private message
dilpreet

New User


Joined: 18 Mar 2008
Posts: 34
Location: INDIA

PostPosted: Fri Mar 28, 2014 12:54 am
Reply with quote

@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
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2632
Location: NYC,USA

PostPosted: Fri Mar 28, 2014 4:24 am
Reply with quote

Dilpreet,

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

ibmmainframes.com/about55822.html
Back to top
View user's profile Send private message
dilpreet

New User


Joined: 18 Mar 2008
Posts: 34
Location: INDIA

PostPosted: Fri Mar 28, 2014 9:21 pm
Reply with quote

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)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Get two files from one file with diff... DFSORT/ICETOOL 10
No new posts View GDG data which is copied from a ... JCL & VSAM 2
No new posts How to read unpacked field created in... DFSORT/ICETOOL 11
No new posts JCL (SET) variables in input stream data JCL & VSAM 0
No new posts How to add 2 digits to COMP-3 file? DFSORT/ICETOOL 11
Search our Forums:

Back to Top