User`s guide

CHAPTER 6 Components
User’s Guide 91
<PRODUCTS>
<PR_ID>435673</PR_ID>
<PR_NAME>Notebook 235</PR_NAME>
<PR_GROUP1>Notebook</PR_GROUP1>
<PR_PRICE>1455</PR_PRICE>
</PRODUCTS>
</dataroot>
XML Port Manager
Click the XML button of the Data Output property to open the XML Port
Manager.
In the upper area of the window, you can view the source XML document. The
left section of the lower window contains two tabs:
• The Data Model tab displays the generated relational schema.
• The Reference tab displays the available component variables.
The right section of the lower window is the port area in which one or more
ports can be defined. Each port is described by a
SELECT statement based on
the XML Data Model tables.
The Data Model
There is one table for the root element (TAB_dataroot) followed by one or
more tables for elements on level 1. In the example, only one element on this
level exists (TAB_PRODUCTS). On the next level, you find a table for each
element on level 2 (TAB_PR_ID, TAB_PR_NAME, TAB_PR_GROUP1,
TAB_PR_PRICE). There can be more nested levels in the XML document,
each level will create another set of table.
Note You can change the prefixes for the generated table names in the DB
Schema Options property.