Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
skip header records from input file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: skip header records from input file
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Thu Mar 27, 2014 9:16 pm    Post subject: Reply to: skip header records from input file
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

Moderator


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

PostPosted: Thu Mar 27, 2014 9:59 pm    Post subject:
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    Post subject: Reply to: skip header records from input file
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

Senior Member


Joined: 21 Sep 2010
Posts: 1818
Location: NY,USA

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

Dilpreet,

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

http://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    Post subject: Reply to: skip header records from input file
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 1 Tue Nov 21, 2017 9:23 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm
No new posts Matching and unmatched records!! Vignesh Sid SYNCSORT 3 Thu Nov 09, 2017 11:22 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us