Field | Definition |
Basic Tab | |
Name | Required field. Specify the attribute name as it will appear in the output XML file. For example, <element attributeName="attributeValue" />. |
Value | Required field. Specify the value of this attribute. This may be expressed by a combination of constant values and RowSet column references. For example ${rowsetVariable[2]}, where rowsetVariable is the name of the variable of type RowSet and 2 is the column index of that RowSet. Please note that only RowSets which are in use by a parent For-Each element may be used. |
Type Conversion Tab | |
Type | 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. Default Value: Same as input. |
Pattern | 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. Default Value: Inherited from the parent Task element. |
Locale | 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. Default Value: Inherited from the parent Task element. |
Data Options Tab | |
Trim | Specify how the leading and trailing white spaces in this element should be trimmed. Default Value: Inherited from the parent Task element. |
Null Substitute | Specify the value that should be written to the output file when this element of the input RowSet has a null value. Default Value: Inherited from the parent Task element. |