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

Usage of SKIPREC in ICETOOL of DFSORT


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

New User


Joined: 10 Aug 2006
Posts: 23

PostPosted: Mon Sep 11, 2006 6:35 pm
Reply with quote

Hi,

My requirement is to skip certain records until specific condition is met.

For example:

My input file looks like this,
Code:
111111
kgskgs
ajggfa
sdgdfvasfjsvf
sfjghasfjaghf
asfjghfjhasf
asvfasj
asjgfasjf
111111


Now, If DFSORT reads and processes the record 111111, it should skip all the records until next 111111 record is found.

I want to do this only with DFSORT or ICETOOL. If SKIPREC doesnot support this functionality, please guide me towards suitable option.

Thanks in advance.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Sep 11, 2006 9:11 pm
Reply with quote

SKIPREC only skips a specified number of records (e.g. skip first 5 records). It cannot skip groups of records. You can use the technique shown in the "Include or omit groups of records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/index.html

to do this kind of thing.

If you need more specific help, you need to give a better example of your input records (with more than one group) and expected output records, and explain clearly the "rules" you want to use to determine which groups should be skipped. Also, give the RECFM and LRECL of the input file.
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 Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
Search our Forums:

Back to Top