User`s guide

Source components
90 Sybase IQ ETL 4.1
DB Schema
Select the file containing the database schema setup (create tables) script. Use
this option to enforce a fixed data model.
DB Schema Options
Customize the settings for tables and attributes being generated from the XML
structure, such as the prefixes for table and attribute names.
DB Options
These are advanced options to configure the underlying internal database.
Read Block Size
This option defines how many records are read from the query result set in one
step. It applies only to components with a single output port in the simulation.
With a value of 0 (default) all records are delivered in one output block.
Setting up the XML via SQL component
This section guides you through the three steps of the setup process for the
component using a simple example.
To follow the example, use the PRODUCTS.xml file as the XML source. It is
located in the Demodata subdirectory of the Sybase IQ ETL Development
installation directory.
XML source
The following XML document is a simple product structure. Each product is
described with an ID (PR_ID), a name (PR_NAME), a product group
(PR_GROUP1), and a price (PR_PRICE), for example:
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-solonde-com:demodata"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="PRODUCTS.xsd"
generated="2005-01-24T16:13:26">
<PRODUCTS>
<PR_ID>435672</PR_ID>
<PR_NAME>24 CD Rom Drive</PR_NAME>
<PR_GROUP1>CD Rom</PR_GROUP1>
<PR_PRICE>134</PR_PRICE>
</PRODUCTS>