XML Output stage

[sri75]

Hi , I am writing data to xml file. we get data from different tables and needs to append the different xml chuncks from different tables to final xml.


I have 2 records coming from the incoming process
2 records have same amount- the oout put from the xml is like this,
<CvrTypeInfo>
<CvrPlanName>DENTAL</CvrPlanName>
<CvrPlanName>MEDICAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>

but I need like this

<CvrTypeInfo>
<CvrPlanName>DENTAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>
<CvrTypeInfo>
<CvrPlanName>MEDICAL</CvrPlanName>
<SubTotalAmt>20</SubTotalAmt>
<CvrMbrInfo>
<CvrMbr>SUB, SPOUSE</CvrMbr>
</CvrMbrInfo>
</CvrTypeInfo>

Ccan you plese suggeste me how to achheive this. if the amounts are different I am getting what I want, but if the amounts are same. I am not

Thanks in advance

[arunkumarmm]

What is the column that you have defined as key?

[Pavan.daddhu]

What is the column that you have defined as key?

Hi,

Please Keep unique key column in xml file.

Unique key is like a Sequence number.

It will work.....

[ray.wurlod]

Parallel job (as marked) or server job (as posted)?

[chulett]

We're going with "as marked".