Processing NULLs and empty values (DataStage®)

XML Output can replace NULLs with empty values, and replace empty values with NULLs.

For a NULL column (SQL NULL), you have two options:

• Generate no element or attribute. This is the default behavior.
• Replace the NULL with an empty element or attribute.

For an empty column (empty string), you have two options:

• Generate an empty element or attribute. This is the default behavior.
• Replace the empty string with no element or attribute.

The final node in the XPath expression determines whether an element or attribute is involved.

For information about configuring replacements, see Transformation settings page.