DB-to XML-Data Source Editor

Relational database support is available only in Stylus Studio XML Enterprise Suite and Stylus Studio XML Professional Suite.

You use the DB to XML Data Source editor to

Define the SQL/XML SELECT statement you want to use to query the database

Optionally, define the SQL/XML UPDATE and INSERT statements you want to use to modify the database

SELECT Tab

You use the
SELECT tab to compose the SQL/XML SELECT statement you want to use to query the relational database. You can compose the SELECT statement manually, by typing directly in the editor, and you can drag and drop tables and columns from the database tree onto the editor.

Tip

When you drag and drop from the database tree, Stylus Studio displays a pop-up menu to help you compose your SQL/XML statement.

UPDATE Tab

You use the
UPDATE tab to compose the SQL/XML UPDATE, INSERT, and/or SELECT statement you want to use to write XML back to the relational database. You can compose the statement manually, by typing directly in the editor, and you can drag and drop tables and columns from the database tree onto the editor.

UPDATE and INSERT actions are always performed against the same database from which the SQL/XML query extracted the data.

Tip

When you drag and drop from the database schema tree, Stylus Studio displays a pop-up menu to help you compose your SQL/XML statement.

Database Schema Tree

You use the database schema tree to review the tables in the database to which you have connected. You can expand and collapse leaves on the tree, and drag and drop tables and columns onto the SQL/XML editor
SELECT and
UPDATE tabs.

Tip

When you drag and drop from the database schema tree, Stylus Studio displays a pop-up menu to help you compose your SQL/XML statement.

Stylus Studio displays the database tree by default once you connect to a database server. You can toggle the display by clicking the
Show/Hide Database Schema button (
) in the editor's tool bar.

Note

Once Stylus Studio has executed the query, the connection to the database is dropped. If you want to refresh the database schema displayed in the database tree, click the
Connect button again.