MVSFORUMS.com

[ikumar]

Hi,
how can the below task can be done using sort/icetool?
input data:
aaaa
aaaa
bbbb
bbbb
bbbb
cccc
cccc
cccc
cccc

data tag needs to be included before bbbb row starts and after bbbb row ends.

output data:
aaaa
aaaa
data
bbbb
bbbb
bbbb
data
cccc
cccc
cccc
cccc

I want this to be done without splitting the file data. I want this to be done like read through each row and when bbbb row starts put "data" tag and when it ends put "bbbb" tag without actually splitting data using sort/icetool.

is it possible to do this?

[Frank Yaeger]

Can we use before the start of the first 'cccc' row, instead of after the end of the last 'bbbb' row, to identify where the second data tag goes?

If not, are there always three bbbb records or can there be a different number of bbbb records? Is it always the second group of records you want the data tags around? I'm looking for more information about the pattern here that we can use.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[kolusu]

ikumar,

Try this DFSORT/ICETOOL job.

[ikumar]

Hi Kolusu,
I tried your solution but it did not work out for me. It seems, i do not have latest icetool PTFs as it is throwing error at IFTHEN and OVERLAY statements. Is it possible to do without using those statements?

Hi Frank,
I want to have the data tag only before and after bbbb. Any number of bbbb data lines can be present and it may not always be second group.

Thanks,
kumar

[kolusu]