602SQL Documentation Index  

Conditional Output to XML

Depending on the data, a certain degree of variability to the XML output may be acquired. Certain elements or attributes can appear in XML, only if certain conditions are fulfilled in the data. If the condition for element output is not fulfilled, nothing inside this element will be in the output.

The condition that specifies whether an element should be in XML can be specified in the element description in the Element output condition field. The condition that specifies whether an attribute should be in XML can be specified in the attribute description in the Output condition field.

Specifying Conditions in an Analytic DAD

The condition in an analytic DAD is a predicate in the SQL language. You may use any expression that will result in a boolean value.

If you use the DAD containing conditions for transferring data from XML to a database, these conditions will be ignored.

Specifying Conditions in a Synthetic DAD

You can only use the column name from the query as a condition in a synthetic DAD. This column must be a boolean type.

If the condition is expressed with a expression, you must add this expression to the SELECT section in the query and mark it with an identifier using the AS clause. Specify the identifier in the field for the condition in the description of the appropriate element or attribute.