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.

For More Information

Composing SQL/XML in Stylus Studio

 
Free Stylus Studio XML Training:
W3C Member