DSXchange

Hi

I have 1 line items XMLs. I need to put these 3 elements into the Orders element

Ex:

job:

dataset1--------XML1----------|
lookup --------XMLoutputstage
dataset2 -------XML2----------|

XML2 will give 3 line items
XML1 will give XML: <Order><a><b></Order)
XML2 will give XML: <Line_Item>
for Lookup key I have used dummy columnwith value 1 so that it will not fail.

Target: <Order><a><b><line_item></Order>

Can anyone help me...how to achieve this requirement.

thanks
kamal

XLM is for true a bit complicated. With your DataStage-CD come sample XLM-DataStage-Jobs and sample XLM-Input- aund XLM-Output-Files. Install them in on of your projects an look at them, you will learn for sure a lot about XLM and DataStage.

Hi Kamal...

Unfortunately I don't entirely understand what you are trying to accomplish...can you be more explict about the sources, the links and stages, and the desired output...

Thanks.

Ernie