Other Ways to Register a Database Configuration

If you choose, you can explicitly register a database connection by dropping any elements from a database connection displayed in the File Explorer window (the connection representation, database, schema, table, or view) on the schema pane of the XQuery Source tab. You might want to do this when you want to view a table's or view's columns prior to writing your XQuery code, so you can see what data structures are available, as shown here:

Figure 335. Schema Pane Shows Table and View Columns

This also gives you the ability to close the File Explorer window after creating your database connection - providing more room to work, and simplifying the Stylus Studio desktop display.

Tip

 

You can also gain access to column-level information about a database's tables and views directly from the File Explorer window by selecting Read Structure from the table or view shortcut menu (right-click).

Choosing a Database Object

You can register a database connection by dragging any database object from the File Explorer window. The object you select affects which objects you can then query in your XQuery code:

  • Server - all of the server's databases and their child tables and views can be queried
  • Database - all of the database's tablespaces and their child tables and views can be queried
  • Tablespace - any of the tablespace's tables or views can be queried
  • Table/View - only the table or view can be queried
  • Column - only the column can be queried

Once you register a database connection to the XQuery document, the configuration information remains associated with the XQuery document until you explicitly delete it from the schema pane in the XQuery Editor.

XML Editor

Stylus Studio XML editor includes many XML editing utilities and features to simplify XML development, including intuitive XML editing views, integrated XML validation and troubleshooting utilities, XML formatting tools, XML generation tools, etc.

Multi Channel Publishing

Multi channel publishing lets you go beyond single-source publishing of HTML and PDF to also generate simultaneously for non-document forms, such as to communicate with partners or drive spreadsheets.

XSLT Mapper

Simplify XSLT mapping with the Stylus Studio XSLT Mapper - supports multiple data sources, round-trip engineering (synchronized editing views), XSLT function blocks, integrated XSLT preview and more.

Support for US National Library of Medicine (NLM) Document Type Definitions

Stylus Studio provides support for editing and validating XML documents using US National Library of Medicine data models. In this tutorial, we'll provide a step-by-step overview of how to use the NLM DTD's in Stylus Studio!

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member