Home >
Online Product Documentation >
Table of Contents >
DB-to XML-Data Source Editor
DB-to XML-Data Source Editor
|
|
|
Relational database support is available only in Stylus Studio XML Enterprise Edition and Stylus Studio XML Professional Edition.
|
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.
|
For More Information
Composing SQL/XML in Stylus Studio
Cart
