hotmoriI have some problem with migration Oracle 10g PL/SQL to DB2 v9.1 for z/OS.

We have PL/SQL procedures that receives a varchar2 type parameter in XML format for it parsing and generating some insert statements using dbms xml package. Now we have to translate this procedures to DB2 with the same functionality. I can't find a method to handle with XML data in DB2,

so can anyone give me a way to xml parsing DB2 as Oracle does? or another simple way?


Thanks for any suggestions in my problem

The first,
You can try the recommendations from IBM RedBoos - Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows (Chapter 8. XML conversion) - http://www.redbooks.ibm.com/abstracts/sg247048.html

The second,
you can use the following resource IBM - IBM Migration Toolkit
http://www.ibm.com/developerworks/data/downloads/migration/mtk/

As far as I know at IBM there is a special group to perform the migration - DB2 Migration Team.
More detailed information can be found in the IBM SWG or IBM GTS.

In addition,
DB2 must maintain compatibility mode with ORACLE.

PS: I recommend to look - http://www.ibm.com/developerworks/search/searchResults.jsp?searchType=1&searchSite=dW&searchScope=dW&query=migration+to+db2&Search=Search

Kind regards,
Vadim Golovsky.