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 >

Using XSLT Templates

Using XSLT Templates is an online video demonstration of the Stylus Studio XSLT designer. See just how easy it is to create, apply and match XSLT templates to your XML data to create beautiful HTML layouts for XML content publishing applications.

Government Agencies That Use Stylus Studio

Government agencies all around the nation are pledging their allegiance to Stylus Studio. Come see which government agencies are using the only XML IDE by the people and for the people.

Translating X12 Documents to XML

The X12 to XML Converter is a built-in function of the adapter library. The XML that is generated is well commented and indented, and can be used anywhere XML is normally used — with XML Schemas, XSLT, XQuery, etc.

Getting EDI to XML and back to EDI Again: Round Trip Engineering using Stylus Studio URL Adapters

A free online video demonstration shows how to use Stylus Studio's Adapter URL technologies to convert EDI to XML and back again. Convert, validate, view and edit EDIFACT data directly in Stylus Studio.