DB2 application development overview - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 36

5. Create XML query.
Workbench can discover and generate the XML schema, but you can also
add XSDs, DTD, and schema to the XML Schema Documents folder (This
folder is located under the recently created project in the Data Project
Explorer pane).
Right-click XML Queries and choose New XML Query . Name the query.
Here we used Sample_XML_Query . Once you click Next , the Add
representative XML documents window appears. Click the Add button on the
right. On the Specify document location panel, choose Database . See
Figure 1-22. Select Next .
Figure 1-22 XQuery Visual Builder: specifying the document location
6. The XML column or Schema window displays (Figure 1-23 on page 37).
Select the schema, which contains the sample database, in this example, the
schema is CHUNJ . We use the CUSTOMER table, which contains two XML data
type columns ( INFO and HISTORY ). Choose the INFO column, and click Next .