Filter
Top Products
Chapter 6. RDB and XML integration 119
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 6-9 is showing the result
xml from SQL to XML wizard. This xml is representing a record of the customer
database and we will insert new record into the database.
Example 6-9 Customer.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SQLResult SYSTEM "Customer.dtd">
<SQLResult>
<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 right-click on the
customer.xml or the XML, which is representing the customer record on your
workbench. Select Generate -> Database data and open the XML to SQL
wizard window (Figure 6-9). We already defined the connection to the airline
database, so we will reuse it by clicking the use existing connection box, then
click Next.