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.

2. Select the data source you want to open.

3. 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.

< Previous | Next >

Download a 15 Day Free Trial Now >

See What's New for 2012 in Stylus Studio X14 >

Purchase Stylus Studio X14 Now >

Deltek Adds XML Support to Advanced ERP, Financial and HR applications with Stylus Studio

Learn how Deltek uses Stylus Studio to build ERP, financial, HR, and project management applications for the professional services industry and large government systems integrators.

XML-DEV Blog

Join the XML Development discussion at XML-Dev - the hottest place to talk about XML technologies, trends, systems architecture and all the latest buzz. Bookmark this RSS and ATOM feed now!

Stylus Studio 2006 R2 Release Notes

ADO to XML

The Stylus Studio ADO to XML data coversion wizard simplifies extracting of relational data into any XML format.