
http://www7b.software.ibm.com/wsdd/techjournal/0204_russell/russell.html http://www.xml.com/pub/a/2000/11/29/schemas/structuresref.html
6.2 The XML to SQL wizard
The XML to SQL wizard enables to insert or update the database record using an XML. It works as the opposite way to SQL to XML wizard and this wizard is available on Application Developer V5 above. Example
Example 6-9 Customer.xml
<?xml version="1.0"
<CUSTOMER>
<FIRSTNAME>Osamu</FIRSTNAME>
<LASTNAME>Takagiwa</LASTNAME>
<SERIAL>6287</SERIAL>
<EMAIL>osamu@itso.com</EMAIL>
</CUSTOMER>
</SQLResult>
Go to the navigator view of the XML Perspective, then