DataFlux Data Management Studio 2.5: User Guide

XML Column Output Node

You can add an XML Column Output node to a data job to collect columns in a row into XML that is placed in a column. For example, you could use this node in conjunction with the XML Column Input node with Web Service node. You could also use column input and output when you need to pull data out of data sources that are stored as XML.

Once you have added the node to the job, you can double-click it to open its properties dialog. 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 field - Specifies the name of the column to receive the constructed XML.

XML grouping indicator field - Specifies the field used to group incoming rows processing.

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 XML element fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the XML generated by the node. 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 generated XML.

Additional Outputs - Displays the Additional Outputs dialog. This dialog enables you to specify the fields that you can make available to the next node in your data job.

Export - Exports field definitions from the Selected grid to a standard DataFlux field definition (.dfl) file. A standard Windows File Save dialog will be displayed, allowing the user to denote the .dfl file.

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

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

Doc ID: dfDMStd_XML_Col_Output.html