Server XML Output Stage Structure

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gsbrown
Premium Member
Premium Member
Posts: 148
Joined: Mon Sep 23, 2002 1:00 pm
Location: USA

Server XML Output Stage Structure

Post by gsbrown »

Writing a simple DS Server job using XML Output to produce this

Code: Select all

<payment>
                <jeweler_code>15498</jeweler_code>
                <invoices>
                                <invoice>
                                                <invoice_no>50000000005</invoice_no>
                                </invoice>
                                <invoice>            
                                                <invoice_no>50000000007</invoice_no>
                                </invoice>
                </invoices>
                <type>CHEC</type>
                <payment_no>123469</payment_no>
                <payment_date>2021-11-26</payment_date>
</payment>
However, it's producing this and can't figure out how to make it structure <invoice> repeated like above.
Any ideas how to specifically control that?

Code: Select all

<payment>
                <jeweler_code>15498</jeweler_code>
                <invoices>
                                <invoice>
                                                <invoice_no>50000000005</invoice_no>
                                                <invoice_no>50000000007</invoice_no>
                                </invoice>
                </invoices>
                <type>CHEC</type>
                <payment_no>123469</payment_no>
                <payment_date>2021-11-26</payment_date>
</payment>
Post Reply