MQSeries.net :: View topic - Output repeating records within repeating records.

Blacky · Posted: Mon Dec 15, 2003 7:33 am Post subject:

I have been asked to generate a flow to handle a stream of input records within a single message, and generate on output :-

HEADER<info><more info>
TXN_START<yet more info>
TXN_INFO...
TXN_INFO...
TXN_END<subtotals>
... <multiple repeated TXN blocks, with repeated TXN_INFO lines
FOOTER<totals>

I cannot find a way to use MRM to generate output records when I dont know what order the output records will end up in. This is a problem when MRM needs either a fixed number of repeats or a 'repeat count' variable.

It was suggested by a collegue to just make up the output data by appending strings, however I am unable to insert the appropriate newlines in the records.

I ended up creating an output MRM record consisting of repeating NULL terminated lines, then building each line as a STRING and inserting
into the repeating structure.

Then an RCD converted it to a BLOB, a COMPUTE node stripped off the 'repeatcount' which I inserted at the beginning of the record to keep MRM happy, and a further COMPUTE node does a search and replace of NULLS to NEWLINES in the output message.

There has to be a better way!!

BTW using MQSI 2.0.2

OutputMRM format

repeatcount = integer
outputdata <repeated x repeatcount>
outputline STRING null terminated
trailerdata <STRING>

The trailer data is stuff that gets put at the end of the file to mark EOF.
Currently a 'ZZZ'. I could easily have generated it in the outputdata.

My Final solution was
MQInput(xx with MRM for incoming format) ->
Compute(OutputRoot.XML = InputBody) ->
Transform(perform work. Output to MRM) ->
RCD (to BLOB) ->
Compute( strip off REPEATCOUNT ) ->
Compute( replace all NULL with 0x0A ) ->
MQOutput( output to destination ).