Opening a DB-to-XML Data Source

You can open a DB-to-XML data source

  • As a DB-to-XML data source, that is, in the DB-to-XML data source editor. This gives you the opportunity to change the data source's definition, including its connectivity settings and SQL/XML statements, for example.
  • As XML, using any Stylus Studio editor that accepts XML (such as the XML editor, for example). When you open a DB-to-XML data source as XM L, Stylus Studio displays only the XML that resulted from executing the SQL/XML defined on the SELECT tab of the DB-to-XML data source.
To open a DB-to-XML data source:
1. Select File > Open from the menu bar.

Stylus Studio displays the Open dialog box.

Figure 358. Open Dialog Box

2. Click the Relational DB icon to display the files in the DB-to-XML file system.
3. Select the data source you want to open.
4. If you want to open the data source in the DB-to-XML Data Source Editor, click Open.

If you want to open the data source as an XML document:

a. Click the down arrow on the Open button.
b. Select the editor from the drop-down list.

Stylus Studio opens the data source as an XML document in the editor you selected.

Note

 

When you save a DB-to-XML data source that you have opened as XML, any SQL/XML statements you have defined on the UPDATE tab are executed.

XML Whitepapers

Learn how XML can help you meet your business objectives by reading free XML Whitepapers covering XML, XML Schema, XQuery, SQL/XML, and FIXML technolgies employed in real world case studies.

Improving XSLT and XQuery Performance with Stylus Studio

This online video demonstration covers XQuery and XSLT performance tuning using the Stylus Studio XSLT profiler and the XQuery profiler.

XML-to-HTML Mapper

Stylus Studio simplifies XML-to-HTML mapping through the industry's first and only XML to HTML mapping tool based on industry standard XSLT.

EDI Mapping

To transform EDI to XML, whether for X12 or EDIFACT, Stylus Studio provides the design tools and run-time support. EDIFACT, X12 and custom EDI formats can be translated, validated and mapped using the EDI Mapping adapter technology described here.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member