XQuery is designed to retrieve and interpret XML data from any source, whether it is a
database or document. Data is stored in relational databases but it is often required that the
data be extracted and transformed as XML when interfacing to other components and services.
Also, it is an XPath-based querying language supported by most NXD vendors. To perform a
query, you need an XQuery transformation scenario.
Configure a data source for the database.
Configure an XQuery transformation scenario.
Click the Configure Transformation Scenario toolbar
button or go to menu .
The Configure Transformation Scenario dialog box
Click the New button in the dialog box.
The dialog box for editing an XQuery scenario is opened.
Figure: Edit Scenario Dialog Box
Insert the scenario name in the dialog box for editing the scenario.
Choose the database connection in the Transformer drop-down
Configure any other parameters as needed.
For an XQuery transformation, the output tab has an option called
that allows you to run an XQuery in lazy mode. The
amount of data extracted from the database is controlled from the option Size limit on Sequence view
. If you
choose Perform FO Processing
in the FO
tab, the Sequence
Click the OK button to finish editing the scenario.
Once the scenario is associated with the XQuery file, the query can include calls to
specific XQuery functions that are implemented by that engine. The available functions
depend on the target database engine selected in the scenario. For example, for eXist and
Berkeley DB XML, the
Content Completion Assistant
lists the functions
supported by that database engine. This is useful for only inserting calls to the
supported functions (standard XQuery functions or extension ones) into the query .
XQuery transformation is executed against a Berkeley DB XML server as a transaction
using the query transaction support of the server.
Run the scenario.
To view a more complex value returned by the query that cannot be entirely displayed in
the XQuery query result table at the bottom of the Oxygen XML Developer window (for
example, an XMLTYPE or CLOB value), do the following:
- Right-click that table cell.
- Select the Copy cell action from the contextual menu to copy
the value into the clipboard.
- Paste the value wherever you need it (for example, in an opened XQuery editor panel
of Oxygen XML Developer).