MQSeries.net :: View topic - CWF with a Repeating TDS Layer

sboucher

The following is my data layout to be parsed and output in XML:

Logical Model:
DATE Length 8 CCYYMMDD
STORENUM Length 4
CODE Length 6 Repeats
QTY Length 6 Repeats
EOM Length 1 Value :

Note: Quantity and Code can repeat as an unknown number. The End of Message (EOM) is always a :

A typical message stream is as follows and comes in as all string:
| DATE |Stor |CODE| QTY |CODE| QTY | CODE| QTY |EOM
200310282210444444000009555555000015777777002512:

Any ideas on how to deal with the repeating elements would be helpful.
By reading the other posts it sounds like CWF is not an option because I have an unknown number of repeats.

Thanks
_________________
Scott A. Boucher
Database Administartor