Creating a Database Connection

Before you can execute a collection() function in an XQuery document, you need to create a database connection. This is part of the process of making the database tables and views available to the XQuery code.

To create a database connection:
1. Display the File Explorer window if it is not already open ( View > File Explorer).
2. In the File Explorer window, right-click the RelationalDB icon and select New Server from the short-cut menu.

Stylus Studio displays the Connection Settings dialog box.

Figure 331. Connection Settings Dialog Box

3. Specify the information needed to create the database connection and click OK. (See Specifying Connection Settings if you need help with this step.)

The server connection appears in the File Explorer window.

Figure 332. New Database Server Connection

Free Stylus Studio XML Training:
W3C Member