Page 1 of 1

Loading XMLs into Db2 UDB -

Posted: Mon Jun 07, 2010 1:43 pm
by ArjunK
Hi ,
We have requirements around loading data (coming in XML format) into a Db2 UDB data warehouse. In the past we have done it using Datastage ( XML PlugIn Stages) but we are dabbling with using pureXML instead of DataStage . I have read a couple of articles on it but wanted to see if anyone has had first hand experience using it. Any pros , cons , challenges or recommendations that you can provide would be appreciated.

Also, is there a possibility of using Datastage version 7.5 with pureXML? Can we fire Xquery in the Db2 stage in 7.5 to retrieve indivisual XML element values?

Thanks.

Posted: Mon Jun 07, 2010 3:39 pm
by eostic
Have you seen this article? I haven't seen any sites using it, but perhaps this will help...

http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

Posted: Mon Jun 07, 2010 3:45 pm
by eostic
It's possible that the DB2 Connector (new with release 8) is required to understand the pureXML datatypes.........but perhaps pureXML has ways of loading xml from disk, which DS could produce....

Ernie

Posted: Mon Jun 07, 2010 4:25 pm
by ray.wurlod
Is the manual for the DB2 Connector available in PDF format?