MQSeries.net :: View topic

rajesh.mbmq · Posted: Mon Aug 25, 2014 4:58 am Post subject:

my xml structure is

<EMP>
<EMPNO>124</EMPNO>
<EMPNO>120</EMPNO>
<EMPNAME>john</EMPNAME>
<EADD>
<ADD>123</ADD>
<ADD>126</ADD>
</EADD>
</EMP>
I was trying to fecth first value in EADD element by using THE function .

SET OutputRoot.XMLNSC.EMP.EMPNO =THE(SELECT * FROM InputRoot.XMLNSC.EMP.EADD AS P);

output is coming as
<EMPNO>
<ADD>123</ADD>
<ADD>126</ADD>
</EMPNO>

If we use THE function only first value will come as below ,but it iis not coming
<EMPNO>
<ADD>123</ADD>
</EMPNO>