MQSeries.net :: View topic - not getting null value converting xml to Text1

warrior12 · Posted: Fri Apr 13, 2012 12:18 am Post subject:

hi there,

i am converting XML msg to Text Delimited file output.
for this am using two message set one is xml and other is Text1.

1)even its xml message set we are selecting Domain as MRM.
so our mapping logic like:
SET OutputRoot.MRM = InputRoot.MRM;

-------------------
in op message set i m selecting
O/p Policy for missing element : useNullValue
then In Local element of nullable elemts:
Logical property : Nillable=true
Physical Property : Encoding Null=NullLiteralValue
Encoding Null Value= ''

------------------------------------------------
Sample message:

<XXXCode>CD</XXXCode>
<XXXName languageCode="EN">XXXName</XXXName>
<XXXDescription>XXXDescription</XXXDescription>
<XXXCategoryCode>token</XXXCategoryCode>
<XXXSystemCode>ISO</XXXSystemCode>
<EffectiveDate>2001-12-31</EffectiveDate>
<ExpiryDate>2001-12-31</ExpiryDate>
<Conversion>
<ConvertToXXXCode>GE</ConvertToXXXCode>
</Conversion>

in message definition i am having 3 elements in Conversion after ConvertToXXXCode but if remove it from the input message becuase its optional but then in op its not appending delimiter for that.
but if i remove any element in between then its appending ~ for that.

coming op : CD~XXXName~XXXDescription~~token~~ISO~~2001-12-31 ~2001-12-31~GE

expected op: CD~XXXName~XXXDescription~~token~~ISO~~2001-12-31 ~2001-12-31~GE~~

its giving problem only after last elements

can anyone please tell how i can get it.

Thanks.