Posted: Mon Aug 16, 2004 5:27 am Post subject: Dynamic Field length size -MQSI2.1
Voyager
Joined: 13 Jul 2004 Posts: 84
Hi Friends,
I need urgent help. Here's my problem.
We are trying to convert XML message to Fixed length messageset. Since we are getting data in form of xml so for each xml tag value length could be different if size and we are tring to convert into fixed message set format.
for example
<XML>
<NAME>SMITH<NAME>
<XML>
In above "NAME" value could be of different size , So I am looking for solution or function i can use to know the size of VALUE of that filed and truncate the filed length as per fixed length message set format. ?
If you are intending to fix the length of the MRM-CWF (fixed lengtH) field then you can use the ESQL LENGTH and SUBSTRING functions to extract the specific length data you need from your input XML message.
However, it should be noted the MRM-CWF (although primarily a fixed length format), supports variable length elements with the following :
- field with a length based on another sibling numeric field.
- Encoded length fields
- Null terminated strings
- End of bitstream (For the final field of a message)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum