• Chapter 1: Getting Started with Stylus Studio®
• Chapter 2: Editing and Querying XML
• Chapter 3: Converting Non-XML Files to XML
• Chapter 4: Working with XSLT
• Chapter 5: Creating XSLT Using the XSLT Mapper
• Chapter 6: Debugging Stylesheets
• Chapter 7: Defining XML Schemas
• Chapter 8: Defining Document Type Definitions
• Chapter 9: Writing XPath Expressions
• Chapter 10: Working with XQuery in Stylus Studio
  • Getting Started with XQuery in Stylus Studio
  • An XQuery Primer
  • Understanding FLWOR Expressions
  • Building an XQuery Using the Mapper
  • Working with the XQuery collection() Function
    • Using the collection() Function in Stylus Studio
    • How the collection() Function is Processed
    • Creating a Database Connection
    • Creating a collection() Statement
    • Other Ways to Register a Database Configuration
      • Choosing a Database Object
  • Debugging XQuery Documents
  • Using DataDirect XQuery® Execution Plans
  • Creating an XQuery Scenario
  • Generating XQuery Documentation
  • Using XQuery to Invoke a Web Service
  • Using Web Services in XQuery
  • Generating Java Code for XQuery
  • Generating C# Code for XQuery
• Chapter 11: Composing Web Service Calls
• Chapter 12: Working with WSDL Documents
• Chapter 13: Building XML Pipelines
• Chapter 14: Publishing XML Data
• Chapter 15: Integrating with Third-Party File Systems
• Chapter 16: Extending Stylus Studio
• Chapter 17: The Stylus Studio Java API
• Chapter 18: Stylus Studio GUI Reference

Home > Online Product Documentation > Table of Contents > Other Ways to Register a Database Configuration

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 327. 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.

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:

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.