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 >

Java Web Services

Stylus Studio's Web Service Call Composer simplifies Java Web Service development by making it easy to find, invoke, and test any Java Web Service deployed on any popular Java Web Service framework, such as Apache AXIS.

XML-to-XML Mapper

XML to XML mapping tools in Stylus Studio provide a powerful visual interface for mapping XML data from-and-to virtually any data format using industry-standard XSLT and XQuery technologies.

Electronic Data Interchange (EDI) Blog

The EDI-L Blog is the best technical forum for discussing topics related to Electronic Data Interchange (EDI), including EDIFACT, and X12 Technologies. Topics include EDI Software, EDI Standards, EDI applications, EDI examples, and more.

Learn XQuery Visually

Stylus Studio offers three infomative XQuery demonstration videos illustrating Stylus Studio's XQuery Editor, Mapper, Debugger and other advanced functionality. Watch them today!