![](/api/v2/epubs/0738491365/files/bgcc.png)
186 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator
Example B-7 shows the command line version of creating the RWDMKT server
definition.
Example: B-7 XML - Create server statement
CONNECT TO PATTERN;
CREATE SERVER RWDMKT WRAPPER "XML";
CONNECT RESET;
Create the XML nickname
After setting up the XML wrapper and the XML server definition, we can create
the actual link to an XML file, a directory containing an XML file, or a URI.
Example B-8 shows content of the RewardsXML file used in the DFS portal.
Example: B-8 Content of the RewardsXML file
<?xml version="1.0" encoding="UTF-8" ?>
- <!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Bill
Mathews (IBM)
-->
- <!-- Druid Bank Credit Card Rewards
-->
- <Reward xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="C:\MyShares\RewardsXML\Rewards.xsd">
<id>100001</id>
<Short_Name>Travel2004</Short_Name>
<Description>Druid Bank Credit Card Travel Purchase Awards</Description>
<Sponser>DruidBankTravel.com</Sponser>
<Card_Type>VISA</Card_Type>
- <Affiliation>
<Name>We Get You There Airlines</Name>
<Points>3</Points>
<per_unit>1</per_unit>
<unit_type>Dollar</unit_type>
<Marketing_Msg>Use your Druid Bank Credit Card to purchase your "We Get You
There Airlines" tickets at DruidBankTravel.com and receive 3 points for every
dollar spent!</Marketing_Msg>
Note: There can be multiple server definitions for each defined XML wrapper
Attention: Unlike some of the other data sources, there are no user mappings
associated with XML data sources since the federated server user ID must
have access to the XML file or directory.