MQSeries.net :: View topic

madi · Posted: Fri Jan 27, 2006 1:23 pm Post subject: eSQL help

Hi

I am trying to generate an XML from name -value pairs and am using the following code.

DECLARE C INTEGER CARDINALITY(InputRoot.XML.InfoPublish.Item.ItemData.ItemAttr[]);
SET C = C + 1;
DECLARE K INTEGER 1;
WHILE K < C DO
DECLARE cursor REFERENCE TO InputRoot.XML.Publish.Item.ItemData.ItemAttr[K];
SET OutputRoot.XML.Item.ItemData.{FIELDVALUE(cursor.(XML.attr)name)} = FIELDVALUE(cursor.AttrValue.(XML.attr)value);
SET K = K + 1;
END WHILE;

Input Message:

<InfoPublish>
<Item>
<ItemData>
<ItemAttr name="ITEM_NUMBER" status="ADD"><AttrValue value="10217180"/></ItemAttr>
<ItemAttr name="MANUFACTURER" status="ADD"><AttrValue value="Mossimo Red"/></ItemAttr>
<ItemAttr name="SHIPPING" status="ADD"><AttrValue value="all_states_apo_prot"/></ItemAttr>
</ItemData>
</Item>
</InfoPublish>

Ouput MEssage:

- <Item>
- <ItemData>
<ITEM_NUMBER>10217180</ITEM_NUMBER>
<MANUFACTURER>Mossimo Red</MANUFACTURER>
<SHIPPING>all_states_apo_prot</SHIPPING>
</ItemData>
</Item>

Now My problem is, I used this example xml given above which has 3 pairs in it and the code worked fine and the code works for any message upto 6KB.

When I put in an xml which is more 6kB, it is not working!!

I think my code is generic and so should work irrespective of the number of ItemAttrs' in the input msg.

Not working for input message:

<InfoPublish>
<Item>
<ItemData>
<ItemAttr name="ITEM_NUMBER" status="ADD"><AttrValue value="10217180"/></ItemAttr>
<ItemAttr name="MANUFACTURER" status="ADD"><AttrValue value="Mossimo Red"/></ItemAttr>
<ItemAttr name="SHIPPING" status="ADD"><AttrValue value="all_states_apo_prot"/></ItemAttr>
<ItemAttr name="GIFT" status="ADD"><AttrValue value="Y"/></ItemAttr>
<ItemAttr name="POST_OFFICE" status="ADD"><AttrValue value="Y"/>
<ItemAttr name="MERCHANDISE" status="ADD"><AttrValue value="234"/></ItemAttr>
<ItemAttr name="DEPARTMENT" status="ADD"><AttrValue value="2"/></ItemAttr>
...
...
...
</ItemData>
</Item>
</InfoPublish>

Plz help
madi