XML JOB

nguyenh · Post by **nguyenh** » Thu Jan 24, 2008 10:24 am

Hi,

I'm very new to XML datastage. Could someone send me a XML sample code that pulling data from a database table and output to a XML_Output stage?

Thank you very much,
HN

dspxlearn · Post by **dspxlearn** » Thu Jan 24, 2008 1:02 pm

Search --> Your Requirement

Many times this topic was discussed in the recent past.

VCInDSX · Post by **VCInDSX** » Thu Jan 24, 2008 2:10 pm

Hi HN
Search will be the best way to go... You will find a lot of exhaustive topics on XML issues....

The following links are very popular in the community...

http://www-128.ibm.com/developerworks/d ... 0703xiong/

http://www.duke-consulting.com/Download ... ctices.zip

Also refer the XML Pack Guide that came with your client installation documentation (PDF files).

When you run into specific issues, visit here for experiencing grand rescue operations

Good luck,

nguyenh · Post by **nguyenh** » Thu Jan 24, 2008 2:18 pm

Thanks for your response....

However, If you can send/point me to a sample code, it would make it very easy for me to learn.
Thanks in advance,
HN

gateleys · Post by **gateleys** » Thu Jan 24, 2008 2:37 pm

nguyenh wrote: If you can send/point me to a sample code, it would make it very easy for me to learn.

I think the poster VCinDSX just gave you pointers to 2 very informative links on XML stages and how they are used.

nguyenh · Post by **nguyenh** » Thu Jan 24, 2008 2:46 pm

Hi Gateleys,

I just now see it...I will disect through the sample job and see how much I can understand and be able to build the job myself.

Thanks,
HN

VCInDSX · Post by **VCInDSX** » Thu Jan 24, 2008 3:15 pm

I concur with Gateleys. If you walk through the example in the first link, you will be able to get a solid foundation on using XML in Datastage. Depending on your database instance you might have to adjust accordingly. But the ideas are explained in detail.

The second document has time-tested guidelines on best practices...

Good luck,

VCInDSX · Post by **VCInDSX** » Thu Jan 24, 2008 3:17 pm

I concur with Gateleys. If you walk through the example in the first link, you will be able to get a solid foundation on using XML in Datastage. Depending on your database instance you might have to adjust accordingly. But the ideas are explained in detail.

The second document has time-tested guidelines on best practices...

Good luck,

nguyenh · Post by **nguyenh** » Thu Jan 24, 2008 3:58 pm

VCInDSX,

I do not know what to say but you guys are awsome!
I am pretty sure more questions to come...

Thanks,
HN