Home >Online Product Documentation >Table of Contents >Sources

As described in Working with Data Sources, if you plan on generating XSLT for your XML Publisher report you must have specified at least one default source. (Sources are not required for generating XQuery, though it is considered good practice to specify one.)

Table 174. How Additional Source Documents Are Referenced

Language Type	Scenario Property	Referenced in Generated Code As
XSLT	Source XML URL	A global parameter: xsl:param name="input1"
XQuery	Main Input	An external variable: declare variable $input1 as document-node() external

The expression associated with these variable names is displayed on the Parameter Values page of the Scenario Properties dialog box, like the one shown for XQuery scenarios in Figure 564.

Figure 564. Additional Sources Displayed on XQuery (XSLT) Scenario Properties

As you can also see, Figure 564 shows how data sources specified in XML Publisher are represented in the XQuery (and XSLT) editor. This XQuery uses three XML sources:

l videos.xml (it is the default source)

l A relational source from the pubs data base

l A local copy of books.xml, displayed on the XQuery data sources panel using the variable name, $input1, with which it is associated

More About Relational Sources

Relational sources, like the one shown in Figure 564, are referenced in different ways by XSLT and XQuery:

l XSLT code references relational data sources within a document() function:

document('xquery:///jdbc:xquery:sqlserver://ntstylus-dev:1433;table=companies;user=sa;xmlforest=true;schema=dbo;DatabaseName=pubs;urltype=.xml')"

l XQuery code references relational data sources using the collection() function:

collection('pubs.dbo.companies')/companies/ticker

See Working with Relational Data Sources for more information.

< Previous| Next >