How to Open a Table or View as an XML Document

To open a table or view as an XML document:

1. Display the Open dialog box.

2. Click the Relational DB icon.

Two new tabs appear: Browse and URL Builder.

3. Click the URL Builder tab.

4. Complete the connection settings as described in Specifying Connection Settings.

5. Click the Connect button.

The databases for the server you connected to appear in the URL Builder tab. For example:

6. Expand the tree diagram to locate the table or view you want to open as an XML document. For example:

7. Click the Open button.

Stylus Studio opens the table or view as an XML document in the editor you were using when you displayed the Open dialog box. in this example, the authors table was opened as a source document in the XQuery Mapper.

Notice that the document name contains the connection settings used to define the URL in step 4.

< Previous | Next >

SQL/XML Tutorial

Many developers need to be able to write applications that work for databases from multiple vendors. This SQL/XML Tutorial refers to SQL/XML, XQuery, and Native XML Programming Languages to do just that.

Learn SQL/XML

Learn how to access and update relational databases using industry-standard SQL/XML technologies along with Stylus Studio's DB-to-XML editor and File Explorer technologies.

Industrial & Farm Equipment

Industrial & farm equipment manufacturers are mowing away the time it takes for data integration with the power of Stylus Studio 2006! See which top industrial and farm equipment manufacturers are cowboying up with Stylus Studio.

XML Generator

Create sample XML instance documents from any XML Schema using the XML Generator. The generated XML document is always valid, well-formed XML!