Definition

Required field. Specify the element name as it will appear in the output XML file. An element is an XML tag. For example, <tagName>.

Specify the value that will appear in this element. This may be expressed by a combination of constant values and RowSet column references, such as ${rowset[1]}. Only RowSets which are in use by a parent ForEach element may be used.

Specify whether or not this element should be skipped (not written to the output file) if the element does not contain any attributes or child elements. If any attributes or child elements exists, then this value will be ignored.

Specify whether or not this element's value should be enclosed in a CDATA section. For example, <![CDATA[value.

Specify the data type of this element For e.g. integer, date or decimal. If left blank, the input RowSet will be queried to obtain the type element. If the type cannot be determined from the RowSet, it defaults to VARCHAR. The data type specified here can be different than the actual data type in the input RowSet. If the data type is overridden, the task performs appropriate data type conversions when reading the data from the input RowSet.

Specify the pattern to use for formatting the data in this element. This will have effect if and only if the data type of this column is numeric, date, time or timestamp.

Specify the locale to which the data in this element is formatted. The Locale must be of the form [language]_[country], where language is the two character ISO language code and country is the two character ISO country code. The country part may be omitted if the data was formatted to just the specified language. Example locales are - en_US (English/United States), de (German). Please note that this setting will only be used if and only if this element is defined as a numeric or date/time type element.

Specify how the leading and trailing white spaces in this element should be trimmed.

Specify the value that should be written to the output file when this element of the input RowSet has a null value.