Trailer style output from icetool occur
Posted: Mon May 12, 2008 7:28 pm
I have a file about 2000 records, with either a "B", "M", "U", or blank space at position 69, and i'm trying to generate a trailer based on that.
It didn't take me very long to come up with:
which gives output of:
however, i'm looking to get all the data onto one line like:
XYZM000937U000870B000061
I've spent the last few hours going through my manuals and examples, and I haven't seen anything that helped as to how i should approach this, so any help would be appreciated.
It didn't take me very long to come up with:
OCCUR FROM(CACSIN) LIST(RPT) -
HEADER('TYPE') ON(69,1,CH) -
HEADER('NUMBER') ON(VALCNT,E'999999') -
BLANK
HEADER('TYPE') ON(69,1,CH) -
HEADER('NUMBER') ON(VALCNT,E'999999') -
BLANK
which gives output of:
TYPE NUMBER
---- ------
000012
B 000061
M 000937
U 000870
---- ------
000012
B 000061
M 000937
U 000870
however, i'm looking to get all the data onto one line like:
XYZM000937U000870B000061
I've spent the last few hours going through my manuals and examples, and I haven't seen anything that helped as to how i should approach this, so any help would be appreciated.