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

ICETOOL question


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

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Tue Aug 10, 2010 7:23 pm
Reply with quote

I have an input file of 381 LRECL. Some of which has got charcters 'PR" in the 1st position of the record. Some of them dont have it.

I want to have the output to take on the record with 10th ocurence of 'PR" at 1st position till before 25th occurrence of 'PR' on 1st poition.

i.e if input rec

PRkefhwfkhwhlhwhwf....
AB..........
CD........
PR........
........
......
PRporeefwjffwfl (10th occurrence of PR in 1st pos, i want from this in output)
AB..........
CD........
PR........
........
......
RTljwefhwlhwf ( i want till this in output)
PRporeefwjffwfl (25th occurrence of PR in 1st pos)
.........
.........

Please guide me.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA

PostPosted: Tue Aug 10, 2010 8:04 pm
Reply with quote

CICS fan,
Why do you call it ICETOOL question?

Try this

Code:
  INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,2,CH,EQ,C'PR'),PUSH=(382:ID=8)) 
  SORT FIELDS=COPY                                                   
  OUTFIL INCLUDE=(382,8,ZD,GE,10,AND,382,8,ZD,LT,25),BUILD=(1,381)   



Thanks,
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 Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Question for file manager IBM Tools 7
Search our Forums:

Back to Top