This is my first post on this forum, so my greetings to you all.
I'm processing an unloaded DB2 table, in which all the VARCHARS have been padded to their full length, but still have the length field in the first two bytes. So my input record looks like:
So my input fields are all in fixed positions, which is easy enough to process. What I want to do is reformat the output record so that it loses the padding from the VARCHAR fields, so I end up with something considerably shorter, looking like:
All the information needed to do the reformatting is in the input record, and although I've RTFM'd I can't see a way to get DFSORT to produce the output I want. Does anybody know how to make it produce variable length output fields (kind of like parse, but in reverse I guess).