<%@ page language="C#" masterpagefile="~/templates/Documentation.master"  
			inherits="Page" 
			pagetitle="Chapter 12	Accessing Relational Data as XML"
			keywords="Chapter 12	Accessing Relational Data as XML"%>
<asp:content id="DocToc" contentplaceholderid="DocToc" runat="Server" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:asp="http://www.w3.org/1999/XSL/Transform">
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_start2.html">Chapter 1: Getting Started with Stylus Studio</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_edit.html">Chapter 2: Editing and Querying XML</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_flatfileconversion.html">Chapter 3: Converting Non-XML Files to XML</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_xslt.html">Chapter 4: Working with XSLT</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_xslt_xmlxml.html">Chapter 5: Creating XSLT Using the XSLT Mapper</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_java.html">Chapter 6: Debugging Stylesheets</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_schema.html">Chapter 7: Defining XML Schemas</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_dtd.html">Chapter 8: Defining Document Type Definitions</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_xpath.html">Chapter 9: Writing XPath Expressions</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_xquery.html">Chapter 10: Working with XQuery in Stylus Studio</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_webservices.html">Chapter 11: Composing Web Service Calls</a>
    </div>
  </li>
  
  <li class="NavMenuListItemActive">
    <div>
      <a href="d_rdb.html">Chapter 12: Accessing Relational Data as XML</a>
    </div>
    <ul>
      <li>
        <a href="d_rdb2.html#wp269369">Overview of DB-to-XML Data Sources</a>
      </li>
      <li>
        <a href="d_rdb3.html#wp363897">Opening a New DB-to-XML Data Source Document</a>
      </li>
      <li>
        <a href="d_rdb4.html#wp380892">Specifying Connection Settings</a>
      </li>
      <li>
        <a href="d_rdb5.html#wp382333">Working with Scenarios</a>
      </li>
      <li>
        <a href="d_rdb6.html#wp363169">Composing SQL/XML in Stylus Studio</a>
      </li>
      <li>
        <a href="d_rdb7.html#wp371273">Working with Relational Data as XML</a>
      </li>
      <li>
        <a href="d_rdb8.html#wp391719">Using the URL Builder</a>
      </li>
    </ul>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_adv.html">Chapter 13: Extending Stylus Studio</a>
    </div>
  </li>
  
  <li class="NavMenuListItem">
    <div>
      <a href="d_help.html">Chapter 14: Stylus Studio GUI Reference</a>
    </div>
  </li>

</asp:content>
<asp:content id="DocPage" contentplaceholderid="DocPage" runat="Server">
  <a name="wp331853"/>
  <p class="BreadCrumbs">
    <span>
      <a href="/" title="Stylus Studio Home">Home</a>&#160;&gt;
    </span>
    <span>
      <a href="/docs/" title="Online Product Documentation">Online Product Documentation</a>&#160;&gt;
    </span>
    <span>
      <a href="." title="Table of Contents">Table of Contents</a>&#160;&gt;
    </span>
    <span class="BreadCrumbsThisPage">Chapter 12	Accessing Relational Data as XML</span>
  </p>
  <div style="float:right;margin-bottom:1em;" class="navHelp">
    <a class="navHelp" href="d_webservices7.html">&lt;
			Previous
    </a>|
		
    <a class="navHelp" href="d_rdb2.html">Next
			&gt;
    </a>
  </div>
  <a shape="rect" name="wp331853"> </a>
  <h1 class="pTitle">
Chapter 12	Accessing Relational Data as XML

  </h1>
  <hr/>
  <a shape="rect" name="wp411485"> </a>
  <p class="pAnchor">
	
  </p>
  <div align="left">

    <table border="1">

  
      <tr bgcolor="#E8E8E8" align="left">    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411477"> </a>
          <div style="color: #cc0000; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: bold; margin-bottom: 0pt; margin-left: 0pt; margin-right: 0pt; margin-top: 0pt; text-align: right; text-decoration: none; text-indent: 0pt; text-transform: none">

            <img src="images/pro_only_logo.gif" height="32" width="29" border="0" hspace="0" vspace="0"/>


          </div>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411479"> </a>
          <p class="pBody">
&#160;

          </p>

        </td>
    
        <td rowspan="1" colspan="1">
          <a shape="rect" name="wp411483"> </a>
          <p class="pBody">
The features for working with relational data as XML described in this chapter are available only in Stylus Studio XML Professional Edition.

          </p>

        </td>

      </tr>
  
      <caption align="bottom"/>

    </table>

  </div>
  <p class="pAnchor">


  </p>
  <a shape="rect" name="wp367818"> </a>
  <p class="pBody">
This chapter describes the different ways you can access relational data and render that data as XML in Stylus Studio:

  </p>
  <div class="pSmartList1">
    <ul class="pSmartList1">

      <a shape="rect" name="wp408551"> </a>
      <div class="pSmartList1">
        <li>DB-to-XML data sources, which you can use to query and, optionally, to modify data in a relational database from within Stylus Studio</li>
      </div>

      <a shape="rect" name="wp408558"> </a>
      <div class="pSmartList1">
        <li>The URL Builder, which lets you create an XML document based on a table or view you select from a relational database</li>
      </div>

    </ul>
  </div>
  <a shape="rect" name="wp345828"> </a>
  <h5 class="pSidebar">
For more information

  </h5>
  <a shape="rect" name="wp345835"> </a>
  <p class="pBody">
Stylus Studio provides a video demonstration of Stylus Studio's DB-to-XML data source feature. Visit our Web site to view this and other Stylus Studio video demonstrations:

  </p>
  <a shape="rect" name="wp377967"> </a>
  <p class="pBody">

    <a shape="rect" href="http://www.stylusstudio.com/xml_videos.html">http://www.StylusStudio.com/xml_videos.html</a>

  </p>
  <a shape="rect" name="wp342203"> </a>
  <h5 class="pSidebar">
Contents

  </h5>
  <a shape="rect" name="wp342258"> </a>
  <p class="pBody">
This chapter covers the following topics:

  </p>
  <div class="pSmartList1">
    <ul class="pSmartList1">

      <a shape="rect" name="wp196278"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb2.html#wp269369">Overview of DB-to-XML Data Sources</a>
        </li>
      </div>

      <a shape="rect" name="wp374646"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb3.html#wp363897">Opening a New DB-to-XML Data Source Document</a>
        </li>
      </div>

      <a shape="rect" name="wp380733"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb4.html#wp380892">Specifying Connection Settings</a>
        </li>
      </div>

      <a shape="rect" name="wp343424"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb5.html#wp382333">Working with Scenarios</a>
        </li>
      </div>

      <a shape="rect" name="wp365828"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb6.html#wp363169">Composing SQL/XML in Stylus Studio</a>
        </li>
      </div>

      <a shape="rect" name="wp374654"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb7.html#wp371273">Working with Relational Data as XML</a>
        </li>
      </div>

      <a shape="rect" name="wp408577"> </a>
      <div class="pSmartList1">
        <li>
          <a shape="rect" href="d_rdb8.html#wp391719">Using the URL Builder</a>
        </li>
      </div>

    </ul>
  </div>
  <div style="float:right;margin-top:1em;" class="navHelp">
    <a class="navHelp" href="d_webservices7.html">&lt;
			Previous
    </a>|
		
    <a class="navHelp" href="d_rdb2.html">Next
			&gt;
    </a>
  </div>
</asp:content>