PARSE All Matching Fields in a Record



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

PARSE All Matching Fields in a Record

Postby Chris Eberhart » Mon Jan 25, 2010 11:56 pm

I have a need to identify/extract all '69' segments from all records of a VSAM file. All of the '69' segments will start with the same key and will have the same length. There can be from zero to very many '69' segments per record. PARSE is almost ideal, but it only finds the instances I specify, for example, for infile: 0069ABCdje69XYZmdne,
SORT FIELDS=COPY
OUTFIL PARSE=(%00=(STARTAFT=C'69',FIXLEN=3)),
BUILD=(%00)
provides one output record, 'ABC'. I suppose that I could specify up to 100 instances, but there may be more than that in a record.
Has anyone found a slick way of performing an operation like this?
Chris Eberhart
 
Posts: 2
Joined: Mon Jan 25, 2010 10:03 pm
Has thanked: 0 time
Been thanked: 0 time

Re: PARSE All Matching Fields in a Record

 

Re: PARSE All Matching Fields in a Record

Postby dick scherrer » Tue Jan 26, 2010 1:38 am

Hello,

Suggest you post a more representative sample of the input data and what you want as output when that input is processed.

Also mention the recfm and lrecl of the files.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post