parsing XML message
Posted: Mon Jul 11, 2005 5:30 am
Hi All,
My scenerio goes as below, Please help me to solve this...
1.One column in the oracle table is having XML path in .XSD format.This column has 68 rows.
2.We need to take all the rows in the above mentioned column and parse the XML message.
3.Each XML field will be stored in a column in DB2 database(extact coulmns are created for matching the fields in DB2 table).
Please suggest me a design to carry out this process as i am very new to XML parsing stuffs..
Thanks in advance.
Regards,
Sangvi
My scenerio goes as below, Please help me to solve this...
1.One column in the oracle table is having XML path in .XSD format.This column has 68 rows.
2.We need to take all the rows in the above mentioned column and parse the XML message.
3.Each XML field will be stored in a column in DB2 database(extact coulmns are created for matching the fields in DB2 table).
Please suggest me a design to carry out this process as i am very new to XML parsing stuffs..
Thanks in advance.
Regards,
Sangvi