Get Multiple Outputs From Single Input Message

Question

I want to get multiple output from a single XML input message.

<List>
<type>mailbox</type>
<Docs>
  <DocID>38ghjk</DocID>
</Docs>
<Docs>
  <DocID>39ghjk</DocID>
</Docs>

This is how my XML looks it contains more DocID. My requirement is I want separate output messages for each DocID. I tried with while loop but I'm not getting separate messages for each DocIDs. I can fetch all DocIDs but I'm not able to get Separate Output each DocID.

Please suggest any way or solution to do it and please comment for any queries.

You should include your esql code. In the meantime check out the PROPAGATE statement. — Attila Repasi, Dec 23 '17 at 16:51
Thanks Attila PROPAGATE statement within while loop helped me to get separate output for all docIDs. And wish you Very Happy New Year. — Amrit, Jan 03 '18 at 08:51
You should post a answer to your own question with what your solution was. — JoshMc, Jan 09 '18 at 19:39

score 3 · Accepted Answer · answered Jan 12 '18 at 13:18

DECLARE I INTEGER;
DECLARE J INTEGER;
SET J = CARDINALITY(InputRoot.XMLNSC.List.Docs[]);
SET I = 1;
WHILE I < J  DO
SET OutputRoot.XMLNSC.LIST.DocId[K] = InputRoot.XMLNSC.List.Docs[I].DocId;
PROPAGATE TO TERMINAL 'out' delete none;
SET I = I + 1;
END WHILE;

Earlier I was not using propagate statement so I was getting single output but now I'm getting different output for all docid.

score 2 · Answer 2 · answered Mar 12 '18 at 16:34

CARDINALITY is not the Best way to do that, you can do something like:

DECLARE refInDocument REFERENCE TO InputRoot.XMLNSC.List.Docs;
WHILE LASTMOVE(refInDocument) DO
   SET OutputRoot.XMLNSC.Docs.DocId = refInDocument.DocId;
   PROPAGATE TO TERMINAL 'out' delete none;
   MOVE refInDocument NEXTSIBLING;
END WHILE;

You can read more about that at IBM documentation in this link: https://www.ibm.com/support/knowledgecenter/en/SSMKHH_9.0.0/com.ibm.etools.mft.doc/bj28653_.htm

Yeap, CARDINALITY is very bad function for really long lists. And reference is more beautiful. — Aleksawka, Aug 28 '18 at 14:37

Get Multiple Outputs From Single Input Message

2 Answers2