IBM Version 5 manual XML to SQL wizard, Example 6-9 Customer.xml

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.

Chapter 6. RDB and XML integration 119