• Chapter 1: Getting Started with Stylus Studio®
• Chapter 2: Editing and Querying XML
• Chapter 3: Converting Non-XML Files to XML
• Chapter 4: Working with XSLT
• Chapter 5: Creating XSLT Using the XSLT Mapper
• Chapter 6: Debugging Stylesheets
• Chapter 7: Defining XML Schemas
• Chapter 8: Defining Document Type Definitions
• Chapter 9: Writing XPath Expressions
• Chapter 10: Working with XQuery in Stylus Studio
• Chapter 11: Composing Web Service Calls
• Chapter 12: Accessing Relational Data as XML
  • Overview of DB-to-XML Data Sources
  • Creating a DB-to-XML Data Source
  • Specifying Connection Settings
  • Using an ODBC Data Source in Stylus Studio
  • Working with Scenarios
  • Composing SQL/XML in Stylus Studio
  • Working with Relational Data as XML
  • Using the URL Builder
    • URL Builder Compared to DB-to-XML Data Sources
    • When to Use
    • Connection Settings
      • XMLForest
      • Example
      • Sequence Elements
    • How to Open a Table or View as an XML Document
• Chapter 13: Integrating with Third-Party File Systems
• Chapter 14: Extending Stylus Studio
• Chapter 15: Stylus Studio GUI Reference

Home > Online Product Documentation > Table of Contents > Connection Settings

Connection Settings

Connection settings for the URL Builder are the same as those used to define a DB-to-XML data source:

You can specify a new set of connection properties, or you can use a default connection by clicking the Use Default Connection check box. See Specifying Connection Settings for more information.

XMLForest

Stylus Studio supports XMLForest, an SQL/XML function that produces a sequence of XML elements based on the rows in a relational table. You can specify whether or not you want to use XMLForest when using the URL Builder to access a relational table as XML.

Example

Consider a simple BOOKS table with a TITLE row. If you accessed the BOOKS table using the URL Builder alone, the resulting XML would look like this:

<BOOKS>
               
  <row>
               
    <TITLE>A History of Moto GP</TITLE>
               
  </row>
               
  <row>
               
    <TITLE>Motorcycles: Art in Design</TITLE>
               
  </row>
               
</BOOKS>
               

            

Stylus Studio creates the <BOOKS> element as the root, with separate <row> elements for each row in the table, one row for each title.

When you use XMLForest, the resulting XMLis not well-formed - it has no root element, and the data is represented as a sequence of <BOOKS> elements instead of as individual rows, as shown here:

<BOOKS>
               
  <TITLE>A History of Moto GP</TITLE>
               
</BOOKS>
               
<BOOKS>
               
  <TITLE>Motorcycles: Art in Design</TITLE>
               
</BOOKS>
               

            

Sequence Elements

To allow you to work with sequences formed by XMLForest in Stylus Studio, the URL Builder adds a sequence element to the XML. The sequence element acts as a root element, ensuring that the XML is well-formed. The sequence element takes the following form:

<stylus:sequence xmlns:stylus="http://www.stylusstudio.com/xquery">

...

</stylus:sequence xmlns:stylus="http://www.stylusstudio.com/xquery">

In most cases, the sequence element is ignored for display purposes in Stylus Studio.