I have a dataset that contains records with a field, by which I need to create a separate dataset that would contain all occurrences of that field. For example the file, FB100, looks like

value1 other data.....
value1 other data.....
value1 other data.....
value2 other data.....
value2 other data.....
value2 other data.....
value3 other data.....
value3 other data.....
value3 other data.....
value4 other data.....
value4 other data.....
value4 other data.....

My final product must be a series of datasets:

hlq.value1.records
hlq.value2.records
hlq.value3.records
hlq.value4.records

There may be hundreds/thousands of possible values, hence hundreds/thousands of datasets. I have accomplished this in 3 phases, first pass reads the data, uses ICETOOL OCCUR to list the values, second phase reads the OUTPUT and formats DD statements and OUTFIL OUTREC statements, the third phase reads the original data to create the numerous output files. I used a newly created PDSE as the output file whereupon the third phase created several thousand members.

It works, after a fashion, but I'd like a more simple solution.


----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to