DataFlux Data Management Studio 2.5: User Guide

XML Output Node

You can add an XML Output node to a data job to write information from a data job to XML. Once you have added the node to the job, you can double-click it to open its properties dialog. See the usage note: Handling Large XML Files with XML Input Nodes or XML Output Nodes.

The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the node.

XML output file - Enables you to enter the path and name of your data source. You can also click Browse to navigate to the file location. Then, you can double-click a data source to see what specific data tables are available in that format.

Use XQuery from file - Specifies the location of the XQuery file.

Use XMLMap from file - Specifies the location of the XMLMap file. You can use SAS XMLMapper software or you can write a custom XQuery to convert the source XML into a compatible XML map. This node will work with either XMLMap version 1.9 or XMLMap version 2.1. Version 1.9 XMLMaps can be created by the SAS 9.2 SAS XML Mapper. Version 2.1 XMLMaps can be created by the SAS 9.3 XML Mapper. For information about obtaining the SAS XML Mapper, see How can I obtain a copy of the SAS XML Mapper?. For information about essential settings needed to use SAS XML Mapper, see How can I make the SAS XML Mapper work with the XML data job nodes?.

You also need to specify values for the following related fields:

Table Name - Specifies the name of the table to process. If this field is empty, the first table in the XMLMap is processed. If there are duplicate table names, the first occurrence is used.

XQuery output file - Specifies the full path where the generated XQuery file will be saved.

No XQuery or XMLMap - Specifies that neither an XQuery nor an XMLMap file is used.

Additional Options - Enables you to access the Options dialog. This dialog enables you to specify the maximum number of rows returned, specify the number of rows per rowset, set additional classpaths, and add namespaces.

The Output fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

You can access the following advanced properties by right-clicking the XML Output node:

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_PFOutput_XML.html