DSXchange

Hello

I have to generate an XML file with the following hierarchical structure.
(This XML file is import whit XML inport option from a xsd schema)



<List Of Invoice>
<File sequence number> NNN </File sequence number>
<Invoice>
<Header>
</Header>
<Details>
Invoice Line item detail 2
</Details>
<Details>
Invoice Line item detail 2
</Details>
<Summary>
</Summary>
</Invoice>

In my input file I can have X record for once invoice.
Each record is corresponding to a part of the invoice (header, detail ..)

For instance, for each record in the input, there are a generated sequence in the XML file like :
<Invoice>
<Header>
</Header>
<Details>
Invoice Line item detail 2
</Details>
<Details>
Invoice Line item detail 2
</Details>
<Summary>
</Summary>
</Invoice>


I would like to have for x record in input (concerning the same invoice number ) a unique sequence
<Invoice>
<Header>
</Header>
<Details>
Invoice Line item detail 2
</Details>
<Details>
Invoice Line item detail 2
</Details>
<Summary>
</Summary>
</Invoice>

I read the XML PACK designer guide but can't find out something help me.
Does anyone can tell me
- if it is possible to do whith Datastage (7.1)
- If yes , suggest me to get arround thi problem.

Thanks

Welcome aboard! :D

It's not really clear from your description what you are trying to achieve. Is it some kind of summary report - totals for each separate file sequence number perhaps?

Basically, you need the XMLReader stage to strip off the tags and create a stream of data. Process that stream of data columns through DataStage (using Transformer, Aggregator, etc. stage types), then use an XMLWriter stage to create XML from the processed stream of data columns.