Convert records in DB2 tables into XML files

bijojames · Post by **bijojames** » Mon Apr 14, 2008 6:27 am

Hi All
I have some 100 records in my DB2 table. My requirement is to convert those records into separate XML files in such a way that each XML will have the details of one and only one record. Here in this case i want 100 XML file as out put.

How can i desgin a Datastage job for this requirement. Please help me on this

Thanks

chulett · Post by **chulett** » Mon Apr 14, 2008 6:32 am

Sure, utilize the 'Trigger Column' functionality in the XML Output stage to do this. A column that increments per record would do the trick.

bijojames · Post by **bijojames** » Mon Apr 14, 2008 6:35 am

Hi Craig
It will be great if yuo can explain the design details little more..

Thanks

chulett · Post by **chulett** » Mon Apr 14, 2008 6:39 am

It would be great if you checked the documentation, the functionality is well explained there. It is literally as simple as I stated, though.

chulett · Post by **chulett** » Mon Apr 14, 2008 9:13 am

FYI - The online help in the stage is decent, there is the XMLPACK_20_Designer pdf in your Docs directory and lastly there's the XML Best Practices documentation from Kim Duke's website in the 'Tips' section. All are required reading for working with XML in DataStage, *especially* the last one. Well worth your time.