XML Output Structure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Satwika
Participant
Posts: 45
Joined: Mon Jan 02, 2012 11:29 pm

XML Output Structure

Post by Satwika »

Hi Every one,

Good Morning,

I need to generate XML output file in the below format :

<school>
<section>
<Class Id="001" Type="NUMBER" RollNumber="7700"> CRLF
</Class>
<Class Id="002" Type="NUMBER" RollNumber="7300"> CRLF
</Class>
</section>
</school>


I can able to generate as below :

<school>
<section>
<Class Id="001" Type="NUMBER" RollNumber="7700"></Class>
<Class Id="002" Type="NUMBER" RollNumber="7300"></Class>
</section>
</school>


but , The requirement demands that the closing tag needs to come in next line as mentioned

<School>
<seciton>
<Class Id="001" Type="NUMBER" RollNumber="7700">
</Class>
</section>
</School>

Please suggest how to generate in the required format. Thank you,.
Suruchi
Participant
Posts: 16
Joined: Tue Dec 13, 2011 3:21 am

Post by Suruchi »

Are you viewing it with browser or notepad?
Suruchi
Participant
Posts: 16
Joined: Tue Dec 13, 2011 3:21 am

Post by Suruchi »

Are you viewing it with browser or notepad?
Satwika
Participant
Posts: 45
Joined: Mon Jan 02, 2012 11:29 pm

Post by Satwika »

Trying with notepad.. with browser it doesn't give difference for both...
Suruchi
Participant
Posts: 16
Joined: Tue Dec 13, 2011 3:21 am

Post by Suruchi »

Did u try the formating option New Style Line: Unix(LF) or DOS(CR/LF) in Output Properties tab
Satwika
Participant
Posts: 45
Joined: Mon Jan 02, 2012 11:29 pm

Post by Satwika »

Yes , I 'm using 'LF' , for getting the output what i have got :

<school>
<section>
<Class Id="001" Type="NUMBER" RollNumber="7700"></Class>
<Class Id="002" Type="NUMBER" RollNumber="7300"></Class>
</section>
</school>

but i need
<Class Id="001" Type="NUMBER" RollNumber="7700">LF</Class>
Post Reply