Architecting and designing : XML integration with other methods : Data model to XML transformations : Data model integration : Transforming columns
  
Transforming columns
Columns are transformed into either XML element or XML attribute when dragged from the browser or Choices dialog onto an XML diagram, dependent on the value of the XMLDataAsAttribute setting in the sa2001.ini file.
Property transformations
Column to XML element
Symbol:
Type
Element
Name
Name of the column.
MinOccurs
Based on the Default Nullity property of the column if False minOccurs = 1, if True minOccurs = 0.
MaxOccurs
Based on the Unique property of the column if False maxOccurs =*. If True maxOccurs = 1.
Definition:
Type
XML element
Name
Name of the column.
Content
TextOnly.
Data Type
Result of physical data model to XML data type mapping.
Source Column
Dropped column name.
Column to XML attribute
Symbol:
Type
Attribute
Name
Name of the column.
Required
Based on the Default Nullity property of the column if False Required = yes, if True Required = no.
Default
Copy the Default Value property from the column.
Values
 
Data Type
Result of physical data model to XML data type mapping.
Source Column
Dropped column name.
Definition:
Type
XML attribute
Name
Name of the column
See also
Data model integration